I've already mastered writing arrays to separate excel sheets using TDMS functions. What I'm trying to do now is write two arrays of data onto the same sheet in excel using tdms. I'm almost 100% positive I saw someone do this in a forum post I saw like two months ago, but I cannot for the life of me find the forum thread again.
For the sake of not having to explain my entire project, just imagine I'm trying to create a gradebook program for a school's records.
I want each sheet to look something like this:
Teacher Dr. Suess
Class Poetry <----- This top table can be transposed, but bonus points if you get it like this.
Semester Fall 2012
Student Grade 1 Grade 2 Grade 3 Test
Billy
Bobby
Joe
Schmo
Additional Comments
Schmo lacks motivation.
If it's not possible to do this in TDMS, just say so. It's not really worth it for me to try another method like .NET or ActiveX controls at this point. The header information and additional comments can be saved elsewhere. It's more of just a luxury for it all to be on the same sheet.
Thanks to anyone who can help,
Chris
