TOPIC: Saving to an Excel file

Saving to an Excel file 28 Nov 2007 02:52 #36

  • chris.gardner
  • chris.gardner's Avatar
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?

Attachment Doc1.doc not found

Attachments:
The administrator has disabled public write access.

Re:Saving to an Excel file 28 Nov 2007 03:01 #37

  • aellis
  • aellis's Avatar
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.

Logicity Logo White 300

526 S Main St., Suite 805, Akron, OH 44311 USA
855.758.0100
sales@logicitysuite.com