Text Export Cell Range

Toby1 · Posted: Thu Jan 29, 2004 2:13 pm Post subject: Text Export Cell Range

Hi All,

I'm trying to export a spreadsheet as text (csv), but I only want a range of the cells. Is anyone aware of a way to do this? I'm currently only having success exporting the entire sheet. I had thought to use the FilterOptions property of the text filter, but that doesn't seem to work for export (unless I'm using it wrong).

Any help is appreciated.

Toby

DannyB · Posted: Thu Jan 29, 2004 8:29 pm Post subject:

You could use the API to Select the range of cells you are interested in.

Then use the Dispatcher to Copy the selection to clipboard.

Use the API to create new spreadsheet. (It could even be hidden so that it doesn't flash up on the screen.)

Use the Dispatcher to Paste into the new document.

Export the new (invisible) document.

Close the document.
_________________
Want to make OOo Drawings like the colored flower design to the left?

Toby1 · Posted: Fri Jan 30, 2004 7:04 am Post subject:

Thanks. I'll give that a try.

Toby1 · Posted: Fri Jan 30, 2004 9:20 am Post subject:

Okay, that's still not working for me.

I think my problem is that I'm not properly getting the cell range selected for the dispatcher, can you point me at any examples of doing this for spreadsheet cell ranges?