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

    <P>hii,</P>
    <P>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.</P>
    <P>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.</P>
    <P> </P>
    <P>Kindly Help.</P>
  • Replied 8 September 2017, 1:49 pm EST

    <P>Hello,</P>
    <P>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.</P>
Need extra support?

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

Learn More

Forum Channels