Export Stringgrid to an xlslx file.

[seghele0]

Using: Windows10 + Lazarus.
I hope to find a programmer willing to provide me the code to export the contents of a Stringgrid to an xlsx file.
A simple 'form' with one stringgrid and one button to activate the export.
This is far too complex for my low level of programming.
Thanks already.

[winni]

Hi!

Save the StringGrid to a CSV File:

Code: Pascal  [Select][+][-]

1. StringGrid1.SaveToCSVFile('Filename.csv');

And then load the file into Excel.

Winni

[seghele0]

Thanks, but it's not for a CSV, but for an XLSX.
I know I can open a CSV with Excel, but would like an XLSX file right away.
 

 

[wp]

Use fpspreadsheet; you can install it via the Online-Package-Manager. There's lots of documentation in the wiki:

• https://wiki.lazarus.freepascal.org/FPSpreadsheet
• https://wiki.lazarus.freepascal.org/FPSpreadsheet:_Examples
• https://wiki.lazarus.freepascal.org/FPSpreadsheet:_List_of_formulas
• https://wiki.lazarus.freepascal.org/FPSpreadsheet_tutorial:_Writing_a_mini_spreadsheet_application
• https://wiki.lazarus.freepascal.org/TsWorksheetGrid

To get you started I am attaching a simple demo which exports a stringgrid to xlsx (or LibreOffice ods if you uncomment the corresponding line). The demo assumes that there are specific data types in each column and converts the strings of the StringGrid to corresponding types so that the xlsx file contains real numbers or dates rather than strings.

[seghele0]

Hero Member, thanks for the info.
Your code works fine, but the're only numbers in my application, positive and negative (-5;15;-5;-5)
What and where do I need to adjust?
Thanks.
 

[wp]

When you only have Integers (no decimal separator) you can export them with the code shown in the demo for column 0.

Code: Pascal  [Select][+][-]

1.   worksheet.WriteNumber(rowindex, colindex, StrToInt(StringGrid1.Cells[col, row]), nfGeneral);

For floating point values (with decimal separator) you use basically the same code, but replace StrToInt by StrToFloat which works fine when the StringGrid cells contain the decimal separators of your system. If not you should replace it by the function MyStrToFloat of the demo which accepts both point and comma as decimalseparator.

The last parameter, nfGeneral, means that the cells will be in the xlsx file as unformatted numbers. Replace it by nfFixed, 2 to format the numbers with two decimal places (or similar), e.g

Code: Pascal  [Select][+][-]

1.   worksheet.WriteNumber(rowindex, colindex, StrToFloat(StringGrid1.Cells[col, row]), nfFixed, 2);

[seghele0]

Thanks ..... I'll be back in a few days with the result.
 

[seghele0]

WP
May I thank you very much for sending your code (demo application) and the accompanying explanation.
Without your support I personally wouldn't have found out how to solve it.
Your support makes my program even more efficient.
Thank you, thank you.
 

[majid.ebru]

Use fpspreadsheet; you can install it via the Online-Package-Manager. There's lots of documentation in the wiki:

• https://wiki.lazarus.freepascal.org/FPSpreadsheet
• https://wiki.lazarus.freepascal.org/FPSpreadsheet:_Examples
• https://wiki.lazarus.freepascal.org/FPSpreadsheet:_List_of_formulas
• https://wiki.lazarus.freepascal.org/FPSpreadsheet_tutorial:_Writing_a_mini_spreadsheet_application
• https://wiki.lazarus.freepascal.org/TsWorksheetGrid

To get you started I am attaching a simple demo which exports a stringgrid to xlsx (or LibreOffice ods if you uncomment the corresponding line). The demo assumes that there are specific data types in each column and converts the strings of the StringGrid to corresponding types so that the xlsx file contains real numbers or dates rather than strings.

Hi
i know this topic is old but i have a question
is it possible to export stringgrid with style to excel ?
like this

[wp]

What do you mean with "style"? The alternating row colors? The font? Gray background of the grids fixed cells? No Excel row and column headers (A, B, C, 1, 2, 3, ...)?

[majid.ebru]

All cases

[majid.ebru]

Hi

please help or guide me

[wp]

All cases

See attachment

please help or guide me

I don't know from which data this screenshot was created and what you are doing. My crystal ball is in the repair shop...