|
| Inicio → WINDEV 2024 → WD18 - How to convert multi row & column array to format Data to display in Excel |
| WD18 - How to convert multi row & column array to format Data to display in Excel |
| Iniciado por guest, 08,nov. 2014 01:37 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 08,noviembre 2014 - 01:37 |
| How can I format data from an array to a field which will be a cell in an Excel spreadsheet (currently a table column. Currently I am doing an ArrayToString to put the data in the table column/field, then export the table to excel for customer. This is what it currently look like <a class="ExternalLink" rel="nofollow" target="_blank" href="http://screencast.com/t/6mvmrzUa">http://screencast.com/t/6mvmrzUa</a>. I would like Qty to be right aligned and Company Name to be left aligned with 1 TAB in between.? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,noviembre 2014 - 03:18 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 08:26 |
Hi.
Maybe you can use an excel sheet already formated. Just open it, and modify the content.
You can also use VBA to customize the columns format.
Regards,
José Antonio Garrido. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 09:39 |
Hi Dan,
You can use the xls functions.
Create an xlsDocument and fill it with your array directly by programming.
Then you can format cells like :MyWorksheet[nRow,sCol]..Mask="#,##0.00;;"
Another option is OLE automation, but it depends on the presence of Excel.
Regards,
Piet |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,noviembre 2014 - 10:38 |
Thank you for the responses ... I will start working with the excel function
dan |
| |
| |
| | | |
|
| | | | |
| | |
|