Questions regarding DirectRead and DirectWrite

[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.

[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.