Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..!
Guys, is their any macro to export the report in correct format.
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
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
Hi Avinash,
After exporting the straight table data, i am getting the data like below: