Will the datawindow SaveAS to excel use sheets? Saving to excel without excel installed on PC.
Currently PB saves the data into an excel sheet, not the dw/ds to excel, with formatting and other features. May be dw2xls utility could do that. I use that utility to save dw to excel sheets, with some limitations it's working fine. [Limitations are mentioned in their website itself ].
I feel appeon could do add this feature in future releases of PB.
- Sivaprakash BKR
- Friday, 29 November 2019 07:34 AM UTC
Don't know what he means by
Conversion of a set of Datawindows and Datastores to separate spreadsheets of Excel workbook.
in the features list of dw2xls tool.
Looks like export to separate sheet is now possible.
< From website>
Support of Freeform, Grid, Tabular, N-UP, Group, Crosstab, Composite, TreeView and Nested DW styles
Support of Text, Column, Expression types of DW objects
Support of DropDownDW, DropDownListBox, Edit, Edit with Code Table and EditMask edit styles of fields
Conversion of a set of Datawindows and Datastores to separate spreadsheets of Excel workbook
Support of all data types
Support of all kinds of text and data formatting
OLE-components are not required
Excel 97/2007/2010 (XLS/XLSX(OOXML)) format support
Easy-to-use program interface
Good technical support.
- Sivaprakash BKR
- Saturday, 30 November 2019 00:51 AM UTC
I deleted an answer here about not being able to SaveAs() to Excel when Excel is not installed, but .. it turns out there's something else preventing me to save any change, sorry about that. I just tested it and you CAN save as Excel, even when it's not installed.
Please explain "use sheets". It'll save a file, being a workbook with one sheet, if I'm not mistaken.
- Paul Mathieu
- Saturday, 23 November 2019 01:11 AM UTC
Maybe do a CSV and append the criteria. I will look at the XLSX!
OLE needs excel to set a ConnectToObject("excel.application")
- Page :
However, you are not allowed to reply to this question.