Page 1 of 1

File input from Excel workbooks

Posted: Fri Mar 28, 2014 1:19 am
by DFH
Suggested enhancement to the GUI for the file input filter:

When an input file is an Excel workbook, provide a tick box option to Ignore hidden worksheets.

Another related idea: Provide a tick box option to choose Treat each worksheet as a separate input file.
Each inputFilename for this option would need to be derived from the worksheet name.

I have assumed that for multiple worksheets, the way TextPipe currently works would be to process all the sheets into the same output stream.
I have not tested that this is the case. The help file makes no reference to multiple worksheets in an Excel file. Please clarify.

Best regards,

David

Re: File input from Excel workbooks

Posted: Tue Apr 29, 2014 4:36 pm
by DataMystic Support
TextPipe adds a form feed between each sheet in the output file.

For now, I am playing with the filter skipping hidden (and very hidden) sheets. I will look into it more tomorrow.

Re: File input from Excel workbooks

Posted: Fri May 02, 2014 10:00 pm
by DFH
Another two suggestion:
  • Provide a tick box option to get cell contents as formulae rather than as values.
    Provide a tick box option to get cell comments as well, ideally suitably tagged.
David