topic problem with excel file? in Application Development and Automation Discussions

problem with excel file?

Former Member — Thu, 04 Oct 2007 08:45:51 GMT

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.

Re: problem with excel file?

Former Member — Thu, 04 Oct 2007 08:56:31 GMT

Hi,

In the fieldcatalog, please pass values for

row_pos like sy-curow, " output in row

col_pos

Best regards,

Prashant

Re: problem with excel file?

Former Member — Thu, 04 Oct 2007 09:10:17 GMT

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

Re: problem with excel file?

Former Member — Thu, 04 Oct 2007 09:24:30 GMT

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

Re: problem with excel file?

Former Member — Thu, 04 Oct 2007 09:38:32 GMT

Hi prashanth,

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

Re: problem with excel file?

Former Member — Thu, 04 Oct 2007 10:45:23 GMT

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