problem with excel file?

[Former Member]

Hi everyone,

I have an alv report.I have to export the report into a excel file.I exported it by using a standard button(CtrlShiftF9) in the toolbar.I m getting all the data in the report into excel but the problem is the data is not starting from the first row and first column in the excel file.The first two rows and columns are empty.The data is placed from the 3rd row and 3rd column.

I shouldn't format it in the excel by removing the blank columns and rows.When I export the report the data should be palced into excel from the 1st row and 1st column.

Any suggestions please?

Thank you.

[Former Member]

Hi,

In the fieldcatalog, please pass values for

row_pos like sy-curow, " output in row

col_pos

Best regards,

Prashant

[Former Member]

Hi prashanth,

Thanks for the reply.I am getting the output perfectly in the alv.When i export the output into excel file there also the data is exporting perfectly but in the excel sheet the data is starting from 2nd row of the excel directly

[Former Member]

we have two options to download into excel

after getting output just try to download with these options

1) is from System->List-> Save--->local file.

2) is from top of the ALV screen (arrow mark button(->) )

try with both of these.

Thanks

[Former Member]

Hi prashanth,

I have tried that one also but i getting the same problem.

[Former Member]

Hi,

If u use a standard export button of an ALV provided by SAP, I hope by default u get the Date in the first row, next 2 blank lines and then u get the data.

Why don't u add ur own export button in the toolbar and hide the standard export button of an ALV. This may solve ur problem.

-SatyaPriya