Pivot table column width issue or Straight table with horizontal excel export issue

[ashok1203]

Hi All,

I need to display a list of measures on a timely manner in the pivot table like below.

If i use pivot table, it was taking all columns width is same. So,i am not able to display the first column width as expected. If i increase one column width automatically it was reflecting to all other columns. But i need first column width is more compare to all remaining columns. For this i tried Size to data option, Intend option and many in the properties but not able to achieve as expected.

For this, I prepared the same chart in straight table by using the Horizontal option, the required layout am able to achieve but while exporting the table into excel, the table data i am getting as transpose.

Can anyone please help me to achieve.

Thanks in Advance..!

[ashok1203]

Guys, is their any macro to export the report in correct format.

[Frank_Hartmann]

see attached file

sub ExcelExport
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.DisplayAlerts = True
Set xlDoc = objExcel.Workbooks.Add
set obj = ActiveDocument.GetSheetObject("CH01")
obj.CopyTextToClipboard
objExcel.Range("A1").PasteSpecial
objExcel.Range("A1").ColumnWidth = 30
xlDoc.SaveAs "C:\Users\Admin\Desktop\Test.xlsx"
xlDoc.Close
end sub

hope this helps

[ashok1203]

Hi Frank,

i am trying to export the table from the attached QVW. I am getting the below error.

Is this method will work in Access point as well. I need to export the report from the access point like we will use the excel export in charts.

Thanks

[ashok1203]

Hi Avinash,

After exporting the straight table data, i am getting the data like below: