| |

VerySource

 Forgot password?
 Register
Search
View: 792|Reply: 2

Delphi cannot be exported to Excel2007

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-18 19:40:01
| Show all posts |Read mode
How to do
Reply

Use magic Report

0

Threads

3

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-29 14:18:01
| Show all posts
can!
lead:
Excel can be controlled using Automation technology. Such as:
    var MyExcel, MyWorkbook: Variant;
     
    procedure TForm1.Button1Click (Sender: TObject);
    begin
     MyExcel: = CreateOleObject ('Excel.Application');
     MyExcel.Visible: = true;
     MyWorkbook: = MyExcel.Workbooks.Open ('e:\book1.xls');
     MyExcel.ActiveCell.FormulaR1C1: = 'ssssssss';
    end;
     
    If you do n’t know the command in Excel, you can use Excel's “Record Macro” function to record an operation, and then use the method of editing the macro to see what the VBA command corresponding to this operation is.
Reply

Use magic Report

1

Threads

27

Posts

24.00

Credits

Newbie

Rank: 1

Credits
24.00

 China

Post time: 2020-2-2 15:36:01
| Show all posts
Bangding :)
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list