So, I have written a program that searches for excel files with a file name matching a certain format. Based on which format the cell falls into, I pull the data (approx 60-70 cells) and store the data in one of approx three dozen summary sheets. This winds up with maybe 12-50 rows depending on the summary type.
In the past I did this with strings for simplicity as they are easy to search/split/etc. But now, due to the fact that no one here can't keep anything in at least a similar format (i.e. people write different units, micro vs mili, 0.65 vs 65%, and abbreviations) which is unnaceptable.
I am now trying to make this human proof, however, there is a main issue. So, I can format the basic file using custom format, no problem (#"g/ml" for example). But I when I take the data, store it in labview, and write it back to a newly created summary sheet it will not bring the custom (or any) format along.
I found the function to write a custom format, but can't find anything that grabs the current format.
And no, I can't just format the columns in the summary sheet, as they vary for each process slightly...
