plex export to excel with column headers

[Anon Anon]

I am using the plex wiki to export a grid to excel with column headers:

http://wiki.plexinfo.net/index.php?title=Export_Grid_data_to_Excel

I"m getting closer! i get the excel to open up and the data is there with a row for the headers, but they aren't populated. I see in the source code it is using HGFM_GETNAME to get the name of the column in the grid. I cannot figure out which setting I need to have set for my fields. I have tried the triple for name and top label and still coming up with blank. not sure why my first column has the ? Any pointers on what exactly the HGFM_GETNAME is pointing to so I can get those updated for this to work properly would be greatly appreciated. I don't want to have to hard code this for each grid that we implement this into.

below is what i get in excel:

?

1
00100190
2
00100190
3
00100190
5
00100749

Should be:

Transaction ID
Item Number
1
00100190
2
00100190
3
00100190
5
00100749

[George Jeffcock]

you need to have a look in here WinWidgets Help

You really need to check the Panel Desginer for the Grid and check the Column Heading setting for your first field, Most likely there is a local modification here that overwrites the use of top label etc.

[Anon Anon]

Can this be done in the opposite manner? I have an excel sheet with Customer Number and Email Addresses 1, 2,3,4,5 columns with data all below it. I need to be able to export the Excel data into a grid to appropriate columns so I can then save the data to it's table. Any idea?

[Legacy User]

Hi Alex,

we can discuss what is better, c++ or vba...but here goes a couple of examples from Stack Overflow, both vba based:

How to read formatted cell value data using excel vba? - Stack Overflow

Excel VBA - read cell value from code - Stack Overflow

the first one links to vba related method:

Range.Text Property (Excel)

Hope this helps