Hello,

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.

Thanks for the reply.

One more thing when I try protect the excel sheets using the code:

excel>>Activeworksheet>>"1">>Protect("abc")

It gives error Protect method does not exist.

So do we have to define the method or there is some other function to be
used for protecting the excel

Thanks,
Nishit.