Logicity Forum  


Saving to an Excel file - 2007/11/27 18:52 When saving the report in an Excel format, is there a way to specify a sheet name in an existing workbook? If so, does it leave the contents of the other sheets intact?
File Attachment:
File name: Doc1.doc
File size:36352 bytes
  The administrator has disabled public write access.
Re:Saving to an Excel file - 2007/11/27 19:01 Chris,

There is currently now way to accomplish that as the export engine overwrites any file you are exporting to. Here is what I'd typically do as an alternative:

- Set up Logicity to export out to it's own Excel file.
- Create a second Excel file (or use an existing one) and reference the other spreadsheet.

This way the Logicity Excel file will get overwritten with new data periodically and your spreadsheet will automatically get the latest data.

Make sense?

Take care,
Adam
  The administrator has disabled public write access.
Web service currency converter