osmansirmali Posted May 4, 2008 Share Posted May 4, 2008 Hi I want to see data in different columns of excel. For example MyChannel_1 in Column A , MyChannel_2 in Column B and MyChannel_3 in Column C ......... I must use the TABkey on Sequence but I don't know how I will use TABkey in Sequence.... Could you please send me your answers by messages for our excel problem... Thanks all your attentions....... (urgent please...) Link to comment Share on other sites More sharing options...
AzeoTech Posted May 5, 2008 Share Posted May 5, 2008 I'm assuming you are talking about data that has been logged using a logging set. You have three choices: 1) the default delimiter is the comma (,). If you name your logging file with a .csv extension then Excel will automatically recognize it as a comma delimited values and put the data into different columns. If you don't name it with a .csv extension then Excel assumes you are Tab delimited. 2) You can then tell Excel during the file load into Excel that it is delimited by comma instead of Tab. 3) You can tell DAQFactory to log with Tab as a delimiter by putting TAB in the delimiter box on the Details page of the logging set. Note that it is case sensitive, so it must be "TAB" and not "Tab" or "tab". Link to comment Share on other sites More sharing options...
osmansirmali Posted May 5, 2008 Author Share Posted May 5, 2008 Hi Thank's for your answer... I am repeating my problem by different pictures. (in attached PDF file) Please See pictures in attached pdf file and than again answer... Could you please send me neccessary whole information.. Osman daqexcelproblem.pdf Link to comment Share on other sites More sharing options...
AzeoTech Posted May 5, 2008 Share Posted May 5, 2008 What I explained will solve your problem. To get the date formatted correctly, simply select the A column, then format Cells and select the desired date format. The 39572.xxx values are actually date values represented in Excel Format which is decimal days since 1900. I recommend simply making sure your log file name ends in .csv. So, instead of: mydata.dat use mydata.csv Then Excel should automatically put everything in separate columns. Link to comment Share on other sites More sharing options...
marlonln Posted May 18, 2009 Share Posted May 18, 2009 Alright, But how to format Date in excel format? Everytime I tried always shows a bunch of ##########. Not because is to large to fit inside the cells, instead it displays that because the date and time are negatives. Ex: number: 39995147878476. Format Cells>Date> 3/14/01 1:30 PM. Returns: #########. Could you help me on that? Thank you. Link to comment Share on other sites More sharing options...
AzeoTech Posted May 18, 2009 Share Posted May 18, 2009 39995147878476 isn't a valid excel time. 39995.147878476 however is. Somewhere you lost a decimal point I think. Link to comment Share on other sites More sharing options...
marlonln Posted May 18, 2009 Share Posted May 18, 2009 I'm from Brazil, So my PC is set to use "," as decimal point isntead of ".". I changed and worked. Thank you, Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.