Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 77
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 ?



  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
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 ?



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 differences to 2003 questions George Applegate[_2_] Excel Discussion (Misc queries) 0 May 4th 09 08:41 PM
VLookUp - Questions - Spreadsheet setup Cpviv Excel Worksheet Functions 3 September 26th 08 03:13 PM
Inserting a MS Word object into an Excel spreadsheet (2 questions) Phrank Excel Worksheet Functions 1 December 28th 07 02:22 PM
Spreadsheet Questions Metalteck Excel Discussion (Misc queries) 4 June 2nd 05 07:44 PM
Newbie questions on spreadsheet WayneC Excel Worksheet Functions 5 December 22nd 04 02:42 AM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"