dztrucktion Posted December 1, 2011 Posted December 1, 2011 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!
comment Posted December 1, 2011 Posted December 1, 2011 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.
Recommended Posts
This topic is 5110 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now