well thanks for your replay
after work some time with this packages i got works for me what i do and what i understand is.
1.- Workseetbook must be a put it in the component wsworkseet and wstabworksheet
at property workbooksource
reference to workbook
2.- When you open a file we need to open like this
ODlg.Filter:='All spreadsheet files|*.xls;*.xlsx;*.ods;*.csv|All Excel files (*.xls, *.xlsx)|*.xls;*.xlsx|Excel XML spreadsheet (*.xlsx)|*.xlsx|Excel 97-2003 spreadsheets (*.xls)|*.xls|Excel 5 spreadsheet (*.xls)|*.xls|Excel 2.1 spreadsheets (*.xls)|*.xls|LibreOffice/OpenOffice spreadsheet (*.ods)|*.ods|Comma-delimited files (*.csv)|*.csv';
sWorkbookSB.AutoDetectFormat := true;
sWorkbookSB.AutoDetectFormat := true;
if Odlg.Execute then begin
sWorkbookSB.FileName :=ODLG.FileName;
sworksheetGrid1.WorkbookSource.FileName:=sWorkbookSB.FileName;
if sworksheetGrid1.Visible = false then sworksheetGrid1.Visible:=true;
FExcFile.Text :=oDlg.FileName;
end;
first assign the file to open to the workbook
second assign the file workbook.filename to worksheet
this way all work fine
sorry but how i can't open the test file i made some mistakes.
thanks for you help.