Consult warrior, I read with ole execl, how can you obtain all show that in the execl

CodePudding user response:

Demon elder brother is ole farmer, but now he USES the three parties control to read and write excel,

CodePudding user response:

Demon elder brother of the original web site has a lot of ole information, I also have saved some didn't see, don't know where,

CodePudding user response:

Assumptions have OLE to EXCEL, to obtain total workbook, then:
Int nSheetCount=newxls. OlePropertyGet (" Sheets "). OlePropertyGet (" Count ");//total number of working table
StringGrid1 - & gt; RowCount=nSheetCount + 1;
for(int i=1; i<=nSheetCount; I++)
{
StringGrid1 - & gt; Cells [2]. [I]=newxls OlePropertyGet (" Sheets ", I). OlePropertyGet (" Name ");
}