How to prevent inserted columns in Excel
Posted: Wed Jan 06, 2010 3:21 pm
Greetings
I am working with an Excel export that includes two types of data:
1) Table with multiple columns of numeric data.
2) Summary text at the end of the report.
Using StiTable, if only the table is output then for each data column in the table there is a single Excel column. This is good and is what's required. However, if summary text is output to rows following the table numerous empty/random Excel columns are inserted in between the data columns which then makes the Excel workbook unusable (i.e. it's not just a read only report but an Excel workbook that users will use to work with exported data).
Is there a way to avoid this? For example, can lines of summary text be output to the first column of each row whereby the text simply "overflows" onto the following columns as is done for .CSV files and if so please explain how?
Thank you.
I am working with an Excel export that includes two types of data:
1) Table with multiple columns of numeric data.
2) Summary text at the end of the report.
Using StiTable, if only the table is output then for each data column in the table there is a single Excel column. This is good and is what's required. However, if summary text is output to rows following the table numerous empty/random Excel columns are inserted in between the data columns which then makes the Excel workbook unusable (i.e. it's not just a read only report but an Excel workbook that users will use to work with exported data).
Is there a way to avoid this? For example, can lines of summary text be output to the first column of each row whereby the text simply "overflows" onto the following columns as is done for .CSV files and if so please explain how?
Thank you.