Page 1 of 1

Questions regarding DirectRead and DirectWrite

Posted: Mon Nov 24, 2014 3:45 pm
by Sviat
1) How can I retrieve NumberFormat of a cell while loading xls files by calling DirectRead?
2) How can I create files by using DirectWrite?
I've already tried to write only string values without formatting:
- I don't understand how to save to different sheets.
- If I save to xlsx, then everything works fine, but if I choose xls, then there will be no data in the saved document.

Re: Questions regarding DirectRead and DirectWrite

Posted: Wed Nov 26, 2014 9:00 am
by larsa
Hello

1. You can't. DirectRead is only intended for reading cell values.

2. You can only write one sheet. You can write more sheets the normal way.