pcsoft.us.windevCopyright 2026, PC SOFT8 Mar 2016 05:48:02 Z2 Mar 2016 11:27:59 ZHello, We have a requirement where we are using TabletoExcel function to export the data in excel. But it gets exported only on first worksheet. So what we have to do if we want the data to be exported in multiple worksheets of a excel. For example : We are using the following code which creates multiple worksheet with data exported in the 1st worksheet (Budget Description) . So if we want to export data in 2nd worksheet (Currency)also then how we will do in Windev : sFilename is string="BUDGET_"+gsUsername+"_"+ DateToString(DateSys(),"YYYYMMDD") +"_"+ TimeToString(TimeSys(),"HHMMSS")+".xls" sFilename = CompleteDir(fExeDir()) + sFilename TableToExcel(TABLE_Budget_Directory_Excel, sFilename) fCreate(CompleteDir(fExeDir()) + sFilename) MyXLSDocument is xlsDocument MyXLSDocument = xlsOpen(sFilename, xlsWrite) MyXLSDocument..WorksheetName="Budget Description" IF xlsNbWorksheet(MyXLSDocument) = 1 THEN xlsAddWorksheet(MyXLSDocument, "Currency") xlsAddWorksheet(MyXLSDocument, "Simulation Base") xlsAddWorksheet(MyXLSDocument, "Export to PIMS") END xlsSave(MyXLSDocument) xlsClose(MyXLSDocument) Thanks, Nishit.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)nishit_devanipcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56739/read.awp8 Mar 2016 05:48:02 ZHello , Thank you all for the feedback and suggestions. I have managed to protect the excel file on export using the follo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56739/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56739/read.awpAdd data in the second worksheet and third worksheet when we do table to excel functionSebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56687/read.awp3 Mar 2016 12:56:09 ZNishit, I'm not shure what your question is. But you can write to different worksheets in your Excel file like this: [code…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56687/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56687/read.awpAdd data in the second worksheet and third worksheet when we do table to excel functionfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56683/read.awp3 Mar 2016 10:55:17 ZHi You can use all the methods available in excel VBA. I have no idea if protect is one of them, as this is a VBA question, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56683/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56683/read.awpAdd data in the second worksheet and third worksheet when we do table to excel functionnishit_devanipcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56678/read.awp3 Mar 2016 08:49:09 ZThanks for the reply. One more thing when I try protect the excel sheets using the code: excel>>Activeworksheet>>"1">>Prot…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56678/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56678/read.awpAdd data in the second worksheet and third worksheet when we do table to excel functionfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56666/read.awp2 Mar 2016 12:50:33 ZHI AFAIK, you'll need to use OLE automation to do that Best regards -- Fabrice Harari International WinDev, WebDev a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56666/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56662-add-data-second-worksheet-and-third-worksheet-when-56666/read.awpAdd data in the second worksheet and third worksheet when we do table to excel function