December 1, 201114 yr I was wondering if there is any clever way to export Excel sheets with custom header titles. For instance, my solution uses z_albumTitle as a field, but to most people that doesn't mean anything, don't even get me started on something like (z_kf_licensingID_trackNumber). I would like it to export these records using something more intelligible, such as Album Title, Track Number - the real kicker is that we export to many different vendors and they all refer to these things differently. Some vendors use CD Title instead of Album Title so on a so forth. Right now, I have to export an Excel file and change the Header names for each report. Any help would be awesome!
December 1, 201114 yr It is possible, if you export as XML and use a custom XSLT stylesheet to transform the result to the Microsoft Excel 2002 XML Spreadsheet format (which is not a "real" .xsl file, but Excel treats it as a native format). Or perhaps you could use a plugin.
Create an account or sign in to comment