+ Reply to Thread
Results 1 to 1 of 1

Importing CSV data and retaining cell formatting upon refresh

Hybrid View

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    New Zealand
    MS-Off Ver
    Excel 2011 (Mac)
    Posts
    1

    Importing CSV data and retaining cell formatting upon refresh

    Hi folks,
    I'm not so hot with Excel so this is really bugging me. I'm generating a CSV .txt file in Matlab, which I want Excel to automatically import and refresh. That works fine. The data is essentially a summary of astronomical observations at our observatory, with each row representing a new star and columns for the star name, number of spectra, dates of observation etc. I may add more columns later. The data is in alphabetical order by star name.

    I want to be able to format this data and add comments in columns off to the side. These comments would be particular to each star, and it would be ideal if they can span multiple columns and perhaps go underneath the star as well. The problem comes when I re-run my Matlab code to refresh the summary data. If we've recently observed a star that we have not taken spectra of before, more likely than not the new star will be inserted in the middle of everything else (because of alphabetical order), which throws off all my formatting (which is tied to the cell itself, rather than the contents of that cell). I have attached an image of what I want to be able to do, and to still preserve the "correct" location of formatting and comments when new rows of data are added.

    Screen Shot 2012-12-04 at 11.51.11 AM.jpg

    If anyone can offer some help on how to sort this out that would be fantastic. Thanks!

    Edit: note that for people familiar with Matlab, I am aware of the xlswrite function which would most likely work. However the solution needs to be compatible with Linux / Mac, and xlswrite is Windows only.
    Last edited by joriarty; 12-03-2012 at 09:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1