Export to All in a signle Excel Sheet

navuser1

Hi All,

Using Excel Buffer Can I create a excel sheet which contains the both Header and Line part of a document(PO, SO etc)?

waiting for your reply..

kapamarou

Using Excel Buffer you say Where you want to place any data you want. So you can say ant Cell(x,y) place Sell-To Customer and at Cell(x+1,y+1) place item no from line... You can do whatever you want. You fill the buffer and then send it to excel. So either you don't have a problem or I don't quite get the question...

navuser1

Thanks for your reply.

navuser1

kapamarou wrote:

Using Excel Buffer you say Where you want to place any data you want. So you can say ant Cell(x,y) place Sell-To Customer and at Cell(x+1,y+1) place item no from line... You can do whatever you want. You fill the buffer and then send it to excel. So either you don't have a problem or I don't quite get the question...

Where is Cell(x+1,y+1) In Excel Buffer ??

I think that i hv to use Automation Server Also..

kapamarou

Cell(x+1,y+1) is an example meaning Row X+1 and Column Y+1.


What you need in table 370 is to insert a line With :

Row No. <- This represents the Excel Line.
Column No. <- This represents the Excel Column.
Both make up the Cell.
Cell Value as Text <- This represents the value of the cell.

You don't really need an automation. Everything can be done through table 370 in which an automation is used.

I suggest you investigate this table with it's fields and functions and see an example of how it is used...

You could find a first example in Form 554 Analysis by Dimensions...

navuser1

Thanks =D>

kapamarou

Glad to help.

And a tip: Usually when I use excel buffer I declare it as a Temporary table variable in order to avoid filling the real table and deleting the values after my process has finished...

navuser1

Before insert the data into the Temp table I always delete the data from It.
But you mentioned that you delete the data after all process finished
why??

kapamarou

I said that whenever I use Excel Buffer I declare the record variable as a Temporary in order to avoid having to delete the records first and clearing the records when I finish. Also since many users might be inserting records to that table they may come across problems, since if the variable is not Temporary then the actual database table is filled with data.

navuser1

How can I change the font Size & color of text at the time of Exporting??

kapamarou

viewtopic.php?f=23&t=17881&start=0&st=0&sk=t&sd=a&hilit=Excel+font+color

navuser1

kapamarou wrote:

http://www.mibuso.com/forum/viewtopic.php?f=23&t=17881&start=0&st=0&sk=t&sd=a&hilit=Excel+font+color

This link says about Excel Buffer table modification :!:
[-X

kapamarou

kapamarou wrote:

This link says about Excel Buffer table modification :!:

So? You don't want to modify that table???

navuser1

No. No modification I want.