http://www.winsoft.sk/officfaq.htm
office component suite faq
last updated friday january 03, 2003
q1. how do i open an excel application, workbook, worksheet?
q2. how do i close an excel application?
q3. how do i specify a range of cells?
q4. how do i set cell values?
q5. how do i access directly excel application com object?
q6. how do i access directly excel workbook com object?
q7. how do i access directly excel worksheet com object?
q8. how do i access directly excel range com object?
q9. how do i access directly excel chart com object?
q10. how do i display note indicators?
q11. how do i print a worksheet?
q12. how do i copy content and format of cells?
q13. how do i set cell borders?
q14. how do i set cell font?
q15. how do i find and replace some text?
q16. how do i close excel worksheet?
q17. how do i save the specified word document in html format?
q18. how do i insert the current page number at the begining of each line?
q19. how do i specify a workbook name?
q20. how do i specify a worksheet name?
q21. how do i draw a line in excel worksheet?
q22. how do i place a picture into worksheet?
q23. how do i open a password protected workbook? new!!!
q24. how do i add a table in the word document? new!!!
q1. how do i open an excel application, workbook, worksheet?
excelapplication.active := true; // opens excel application
excelworkbook.parent := excelapplication;
excelworkbook.workbookname := 'c:\myfile.xls';
excelworkbook.active := true; // opens excel workbookexcelworksheet.parent := excelworkbook;
excelworksheet.worksheetname := 'mysheet';
excelworksheet.active := true; // opens excel worksheet
q2. how do i close an excel application?
excelapplication.active := false;
q3. how do i specify a range of cells?
excelrange.range := 'b3'; // one cell selected
excelrange.range := 'a1:b2'; // four cells a1, a2, b1, b2 selected
excelrange.formula := 3; // integer constant
excelrange.formula := 'hello, world!'; // string constant
excelrange.formula := '=sum(b1:b5)'; // formula specification
q5. how do i access directly excel application com object?
use excelapplication property:
with excelapplication1.excelapplication.activecell do
