PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Export a report to excel with format
Export a report to excel with format
Iniciado por guest, 30,jun. 2015 16:11 - 3 respuestas
Publicado el 30,junio 2015 - 16:11
Hello.
I need to export a report to Excel with all his format.
Is there any way without using a standard template?
Best regards,
Tiago Mortinho
Publicado el 01,julio 2015 - 01:14
Hi, look at the excel examples . There are lots of ways to manipulate excel.

regards

Allard
Publicado el 02,julio 2015 - 11:29
Hello.

Thank you very much for your help,
But I need to convert a report in Excel, which keep all formats.
And do not properly manipulate files in excel, programmatically.
The aim is for the customer to develop their own reports and can import into Excel, with the same characteristics.
I know iParameterXLS (iWithFormatting) enables sending the colors, but cell contours do not.
Best regards,
Tiago Mortinho
Publicado el 02,julio 2015 - 12:16
Hi Tiago,

which is why Allard was telling you to look at the examples, as there
are different WAYS to manipulate excel, including via OLE automation,
and this will allow you to do what you want.

If you need to do that on a machine where excel is not installed, you
can also use a .net component called gembox spreadsheet.

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com


On 7/2/2015 3:29 AM, Tiago Mortinho wrote:
Hello.

Thank you very much for your help,
But I need to convert a report in Excel, which keep all formats.
And do not properly manipulate files in excel, programmatically.
The aim is for the customer to develop their own reports and can import
into Excel, with the same characteristics.
I know iParameterXLS (iWithFormatting) enables sending the colors, but
cell contours do not.
Best regards,
Tiago Mortinho