A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

.csv And (Possible) Spreadsheet Differences Questions



 
 
Thread Tools Display Modes
  #1  
Old March 28th, 2010, 12:17 PM posted to microsoft.public.excel.newusers
Bob[_62_]
external usenet poster
 
Posts: 22
Default .csv And (Possible) Spreadsheet Differences Questions

Hello,

Using Excel 2007 and Windows 7.

I have a radio control program that allows one to create an Excel
spreadsheet of frequencies, radio filter characteristics, etc., and
Import it into the program. Then, when using the program, one can tune
the radio to particular frequencies, etc that were put on the spreadsheet.

The Format that the spreadsheet has to be in is very definitive,
but well defined.

It also has to be in .csv format prior to the radio's doing an Import of
them.

So, up to yesterday, I created spreadsheets, and the program had no
difficulty in Importing them.

As of yesterday, it would not do any Import of newly created ones.
The older ones will Import just fine.

It can, of course, be something wrong in the program that became
corrupted, but frankly I don't think so. I did reload the software from
the CD, and did a new reinstall of it. Same problem.

My tentative conclusion is that "something" changed with the Excel.

The spreadsheet that works, and the ones that don't, look to be, other
than the numbers, identical. Both are in .csv format and apparently
identical, other than the numbers in them.

Is there any way to see the actual .csv formated items in the
spreadsheet ? The spreadsheets when I look at them look like the
typically saved Excel Workbook ones, but I realize once I do a Save As
to a .csv format, they are saved very differently.
Any way of seeing the .csv actual formated items ?

What else should I check between the old ones that work, and the new
ones that don't ? At first glance they sure do look identical, but I
keep thinking that there is something, meaningfully different between them.

Any thoughts on this, or things to try or look at, would be most
appreciated.

Thanks, Bob

BTW: the file icon for the saved .csv files have a picture of a page
with the right upper corner turned down a bit, and what looks like a
small "a" with perhaps a comma after it. Is this correct for .csv ?
Is there a list of these icon pix anywhere ?



Ads
  #2  
Old March 29th, 2010, 01:52 PM posted to microsoft.public.excel.newusers
Stefi
external usenet poster
 
Posts: 1,841
Default .csv And (Possible) Spreadsheet Differences Questions

First have a look at your .csv files via a simple text editor (they are text
files separated by commas)! My tip is that your Windows Regional settings
changed therefore some other separator (e.g.) semicolon) is used in Csv file.

--
Regards!
Stefi



„Bob” ezt *rta:

Hello,

Using Excel 2007 and Windows 7.

I have a radio control program that allows one to create an Excel
spreadsheet of frequencies, radio filter characteristics, etc., and
Import it into the program. Then, when using the program, one can tune
the radio to particular frequencies, etc that were put on the spreadsheet.

The Format that the spreadsheet has to be in is very definitive,
but well defined.

It also has to be in .csv format prior to the radio's doing an Import of
them.

So, up to yesterday, I created spreadsheets, and the program had no
difficulty in Importing them.

As of yesterday, it would not do any Import of newly created ones.
The older ones will Import just fine.

It can, of course, be something wrong in the program that became
corrupted, but frankly I don't think so. I did reload the software from
the CD, and did a new reinstall of it. Same problem.

My tentative conclusion is that "something" changed with the Excel.

The spreadsheet that works, and the ones that don't, look to be, other
than the numbers, identical. Both are in .csv format and apparently
identical, other than the numbers in them.

Is there any way to see the actual .csv formated items in the
spreadsheet ? The spreadsheets when I look at them look like the
typically saved Excel Workbook ones, but I realize once I do a Save As
to a .csv format, they are saved very differently.
Any way of seeing the .csv actual formated items ?

What else should I check between the old ones that work, and the new
ones that don't ? At first glance they sure do look identical, but I
keep thinking that there is something, meaningfully different between them.

Any thoughts on this, or things to try or look at, would be most
appreciated.

Thanks, Bob

BTW: the file icon for the saved .csv files have a picture of a page
with the right upper corner turned down a bit, and what looks like a
small "a" with perhaps a comma after it. Is this correct for .csv ?
Is there a list of these icon pix anywhere ?



.

  #3  
Old March 31st, 2010, 09:29 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default .csv And (Possible) Spreadsheet Differences Questions

Bob -- one of the best and handiest simple text editors to use for this is
good old Notepad
Right-click on the .csv file and then choose [Open With...] and pick Notepad

"Stefi" wrote:

First have a look at your .csv files via a simple text editor (they are text
files separated by commas)! My tip is that your Windows Regional settings
changed therefore some other separator (e.g.) semicolon) is used in Csv file.

--
Regards!
Stefi



„Bob” ezt *rta:

Hello,

Using Excel 2007 and Windows 7.

I have a radio control program that allows one to create an Excel
spreadsheet of frequencies, radio filter characteristics, etc., and
Import it into the program. Then, when using the program, one can tune
the radio to particular frequencies, etc that were put on the spreadsheet.

The Format that the spreadsheet has to be in is very definitive,
but well defined.

It also has to be in .csv format prior to the radio's doing an Import of
them.

So, up to yesterday, I created spreadsheets, and the program had no
difficulty in Importing them.

As of yesterday, it would not do any Import of newly created ones.
The older ones will Import just fine.

It can, of course, be something wrong in the program that became
corrupted, but frankly I don't think so. I did reload the software from
the CD, and did a new reinstall of it. Same problem.

My tentative conclusion is that "something" changed with the Excel.

The spreadsheet that works, and the ones that don't, look to be, other
than the numbers, identical. Both are in .csv format and apparently
identical, other than the numbers in them.

Is there any way to see the actual .csv formated items in the
spreadsheet ? The spreadsheets when I look at them look like the
typically saved Excel Workbook ones, but I realize once I do a Save As
to a .csv format, they are saved very differently.
Any way of seeing the .csv actual formated items ?

What else should I check between the old ones that work, and the new
ones that don't ? At first glance they sure do look identical, but I
keep thinking that there is something, meaningfully different between them.

Any thoughts on this, or things to try or look at, would be most
appreciated.

Thanks, Bob

BTW: the file icon for the saved .csv files have a picture of a page
with the right upper corner turned down a bit, and what looks like a
small "a" with perhaps a comma after it. Is this correct for .csv ?
Is there a list of these icon pix anywhere ?



.

  #4  
Old April 2nd, 2010, 01:16 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default .csv And (Possible) Spreadsheet Differences Questions

Bob,
As to what to look for as differences between the old .csv files that work
and the new ones that don't:
#1 - look for a different character as the separator. In the classic .csv
file the separator character is a comma; but other characters can be used
such as the semi-colon ( ; ), the pipe ( | ) and even the tab.
#2 - look for a difference in the use of the double-quote or single-quote
marks (" and ').


"Bob" wrote:

Hello,

Using Excel 2007 and Windows 7.

I have a radio control program that allows one to create an Excel
spreadsheet of frequencies, radio filter characteristics, etc., and
Import it into the program. Then, when using the program, one can tune
the radio to particular frequencies, etc that were put on the spreadsheet.

The Format that the spreadsheet has to be in is very definitive,
but well defined.

It also has to be in .csv format prior to the radio's doing an Import of
them.

So, up to yesterday, I created spreadsheets, and the program had no
difficulty in Importing them.

As of yesterday, it would not do any Import of newly created ones.
The older ones will Import just fine.

It can, of course, be something wrong in the program that became
corrupted, but frankly I don't think so. I did reload the software from
the CD, and did a new reinstall of it. Same problem.

My tentative conclusion is that "something" changed with the Excel.

The spreadsheet that works, and the ones that don't, look to be, other
than the numbers, identical. Both are in .csv format and apparently
identical, other than the numbers in them.

Is there any way to see the actual .csv formated items in the
spreadsheet ? The spreadsheets when I look at them look like the
typically saved Excel Workbook ones, but I realize once I do a Save As
to a .csv format, they are saved very differently.
Any way of seeing the .csv actual formated items ?

What else should I check between the old ones that work, and the new
ones that don't ? At first glance they sure do look identical, but I
keep thinking that there is something, meaningfully different between them.

Any thoughts on this, or things to try or look at, would be most
appreciated.

Thanks, Bob

BTW: the file icon for the saved .csv files have a picture of a page
with the right upper corner turned down a bit, and what looks like a
small "a" with perhaps a comma after it. Is this correct for .csv ?
Is there a list of these icon pix anywhere ?



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.