Add new sheet

toscaleton

Hi i want to do a report who can export to excel, i can do it but i can´t add new sheets. I want to add many sheets that i need.

Thank you

pduck

So how do you create your Excel file? Using the automation I think. Have a look at the Worksheets-Object (not Worksheet !).

toscaleton

Alexander Broz wrote:

So how do you create your Excel file? Using the automation I think. Have a look at the Workheet-Object.

Worksheet-object¿? where¿? in the object designer can´t find it, the code unit 7311 Whse. Worksheet-Create¿?

Thanks

toscaleton

toscaleton wrote:

Alexander Broz wrote:

So how do you create your Excel file? Using the automation I think. Have a look at the Workheet-Object.

Worksheet-object¿? where¿? in the object designer can´t find it, the code unit 7311 Whse. Worksheet-Create¿?

Thanks

i try to find this but i can´t, i´m nobel user in automations, can you explain to me thanks.

vijay_g

table 370(excel buffer) and see functions how they can help you.

toscaleton

vijay_g wrote:

table 370(excel buffer) and see functions how they can help you.

Hi, in excel buffer can´t create more than one sheet in excel or i don´t know how. I need help please.

vijay_g

try...

Excelbuffer.createbook;
Excelbuffer.creatsheet('sheet1',' ',' ',' ');
Excelbuffer.creatsheet('sheet2,' ',' ',' ');
Excelbuffer.creatsheet('sheet3',' ',' ',' ');
Excelbuffer.giveusercontrol;

now in excel it will create six sheet three are "sheet1","sheet2","sheet3" and remaning three is default.

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Hanen

Add function in excel buffer 370:

AddSheet()
XlWrkBk := XlApp.ActiveWorkbook;
XlWrkSht := XlWrkBk.Worksheets.Add;

and then call this function after each createsheet();

Hanen

How can I put each data on the right sheet?

DenSter

Assign each sheet to its own variable.