text to excel for GRIMM data

I have a following data, of GRIMM instrument (11D model). The output text file is very complex. I want to convert into an excel file so that i can proceed with the visualization of data.

One file is attached here for the reference.

[Image Analyst]

Did you try to import the text file into Excel? Excel should be able to do that. Anyway, this is a MATLAB language forum, not an Excel forum. Perhaps there are Excel Q&A forums you can ask.

[AMIT SINGH CHANDEL]

Thank you for your immediate response.

Yes,

I tried but it simply converts the data into rows and columns. And that is of no use to me, because in the uploaded text there are 32 bin size which are placed in top four rows of 8 cloumn each. There respective data is followed in furhter rows and columns in the same manner. I wanted help in arranging that data in 32 column for each size bin and there respective data with dates in subsiquent rows. This can only be done through code.

And I am a beigner, so I needed help from experts to solve my query.

[AMIT SINGH CHANDEL]

Still waiting for an expert to help in this regard

[dpb]

You been just sitting since June for somebody else to do your work for you????

You haven't supplied enough specifics about what you really want/need to provide exact code; what, specifically would you expect an output file/dataset to look like?

There's some confusion about the file content itself...what are the header columns and how do they relate to the records without that many values?

There are sets of four 8-valued records, but they're not labelled consistently; what's the difference between upper and lower case C0 and c0 -- or is it just some anomaly/error in the file construction? And, is there any significance to the the trailing ":" vis a vis ";"?

Then, it starts off with a P, K, P, then a different sequence following P; whassup with that? Not to mention what may be a date/time stamp(?) in the P record initially has _23 whereas is 23 in the rest...such anomalies add to the difficulties in parsing, but it's essentially impossible without knowing what it is that are looking at and what is expected.

Basically, in such cases, one has to read the data by record and parse/rearrange it into the desired format

ADDENDUM: I intended to add, if this file is output by some commercial package, see the vendor's website for tools to read the output file. Oftentimes (at least with the major vendors) there is a MATLAB version already. Or, you may have the option to mex a C function.

Answer 1

[Sulaymon Eshkabilov]

There are a few good MATLAB functions that can be employed to import your data into MATLAB and then export into MS Excel (.xls, xlsx or .csv) format.

For data import: readtable(), dlmread(), textscan(), etc.

For data export: writetable(), writematrix(), xlswrite(), etc.

[dpb]

The problem here isn't the reading, it's the parsing of what has been read to make something useful out of it to write...and there are too many imponderables w/o more input from the OP as to what stuff really is and how/what intends/needs to do with it to take time first...

[AMIT SINGH CHANDEL]

Thank you, I got the way to arrange the data in desired manner.