Topic
  • 3 replies
  • Latest Post - ‏2013-01-30T17:01:58Z by SystemAdmin
kabr
kabr
115 Posts

Pinned topic create excel sheet

‏2013-01-30T12:55:17Z |
Hi all,

while exporting into an existing Excel file I would like to append the data into a new worksheet.

Is there a way to create such a new worksheet in an open excel file before exporting?

thanks in advance.

Karl
Updated on 2013-01-30T17:01:58Z at 2013-01-30T17:01:58Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    3180 Posts

    Re: create excel sheet

    ‏2013-01-30T16:09:15Z  
    The fantastic "Enhanced Export to Excel" from Galactic Solutions (Michael Sutherland) allows you to select an existing Excel file and also to specify the sheet to export to.

    Link: http://www.galactic-solutions.com/downloads/GalacticDownloadExcel.htm
  • kabr
    kabr
    115 Posts

    Re: create excel sheet

    ‏2013-01-30T16:28:05Z  
    The fantastic "Enhanced Export to Excel" from Galactic Solutions (Michael Sutherland) allows you to select an existing Excel file and also to specify the sheet to export to.

    Link: http://www.galactic-solutions.com/downloads/GalacticDownloadExcel.htm
    Well, right, yes.
    But you can only specify a sheet that already exists in the workbook.

    What I want to do is: export into an existing workbook, but not into one of its sheets, because these already contain data I do not want to overwrite. Therefore I want to create a new worksheet inside the specified workbook and then export into that sheet. And I want to do this from the dxl script.

    Karl
  • SystemAdmin
    SystemAdmin
    3180 Posts

    Re: create excel sheet

    ‏2013-01-30T17:01:58Z  
    • kabr
    • ‏2013-01-30T16:28:05Z
    Well, right, yes.
    But you can only specify a sheet that already exists in the workbook.

    What I want to do is: export into an existing workbook, but not into one of its sheets, because these already contain data I do not want to overwrite. Therefore I want to create a new worksheet inside the specified workbook and then export into that sheet. And I want to do this from the dxl script.

    Karl
    Hi

    If you want to create a new sheet, you can use the add-Method

    http://msdn.microsoft.com/de-de/library/microsoft.office.interop.excel.worksheets.add(v=office.11).aspx

    Best regards
    Wolfgang