Has anyone been able to export to unformatted Excel spreadsheet?
when i export data with long names it creates more than one column for one name or item
that does not help me at all as i need to import items one by one to new unformatted spreadsheet
i tried using Report designer
but i dont want to do that every time i need a new report exported
Any ideas how to automat this process?
Try exporting to .csv (near the bottom of choices), this works well for me, I then open in Excel, format to my liking and save as .xls
Retrieving data ...