Export data from Farpoint Spread to a specified sheetname of excel.

Posted by: lier on 8 September 2017, 1:49 pm EST

  • Posted 8 September 2017, 1:49 pm EST

    hii,


    I need to export farpoint spread  data to excel. the first time i do the saving of data, it is saved in the first excel sheet.


    if i use the same excel file to export new data, the previous data in sheet 1 is overwritten. i need that the data should be saved in the sheet2 next time  when i do save the data.


     


    Kindly Help.

  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    This is not possible with our Spread control. Spread creates a new workbook file when saving to Excel. You can use a 2nd "invisible" Spread control to load the Excel file you first created. Then, make a clone of the SheetView that you are trying to append in Excel into the 2nd sheet in the "invisible" Spread and then exportto Excel from the "invisible" Spread.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels