Delete XLS sheet

VCL TMS VCL UI Pack
1

Hello,

I need to be able to delete (not clean) an xls sheet and keep the others in ab xls document.
I cannot fount the way with TadvGridexcelIO. Is it possible? Or with another TMS component?

Also, now I'm adding sheets by using:
Input_Gridio.XLSExport(extractFilePath(application.exename)+
'/projects/'+proj+'.xls','Instr'+IntToStr(actualInstrument),-1,i,insertInSheet_clear);
proj is file name
i is sheet number
What means the '-1'?

Thanks for your help ;-)
Phil.

2

TAdvGridExcelIO has no direct method to delete a sheet. It can only export to an existing sheet or to a new sheet it creates. You could overwrite an existing sheet or alternatively, for a larger set of functions to deal with XLS files, see TMS Flexcel: http://www.tmssoftware.com/site/flexcel.asp