PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Export a report to excel with format
Export a report to excel with format
Débuté par Tiago Mortinho, 30 juin 2015 16:11 - 3 réponses
#1
Posté le 30 juin 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
#2
Posté le 01 juillet 2015 - 01:14
Hi, look at the excel examples . There are lots of ways to manipulate excel.

regards

Allard
#3
Posté le 02 juillet 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
#4
Posté le 02 juillet 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
→ Revenir à WINDEV 2024