CSV and SYLK file.

We used to export data in the form of .csv file that is one of the easiest formats available. A .csv file can be opened in even Notepad and if it is opened in Microsoft Excel, you can perform calculation with the numbers also.
When you open a certain .csv file, Microsoft Excel may show an error that the file is a SYLK file and confirm to open it. Once you confirm it will show error that 'SYLK: File format is not valid'.
If you try to open the same file in Notepad or Wordpad you will not see any issue with the data.
The problem actually lies with Microsoft Excel. If the first two characters of the file are the uppercase letters "I" and "D", then MS Excel will consider the file as SYLK file and if you try to open it with MS Excel it will show error as the file is not actually an SYLK file.

Solution:
Open the file in notepad and change the first two characters of the file to lower case, if they are I and D. So, 'ID' will change to 'id'.

Reference: http://support.microsoft.com/kb/3236263

Comments

Subhadra said…
I use a lot of csv files, but never have faced this problem. Anyway, now I know what I do if I come across this issue.
December 13, 2011 at 9:08 AM
Post a Comment

Popular posts from this blog

Hide notification content in Android lock screen for Messages, email, whatsapp and selected apps.

Image
 Notification in lock screen is helpful to get an idea about the content. But for sensitive information like OTP it will be disastrous.  The feature to selectively hide content in the notification is available in Android. This example is based on Android v.13 and Samsung One UI v.5.0 Follow the steps to selectively disable notification content in the lock screen.
Continue Reading by clicking here >>

Array functions in JavaScript

Here are some of the functions useful for array operations Push() - Appends one or more elements to the end of an array var data = [ "A" ]; data.push( "B" ); data.push( "C" ); Result data = ["A","B","C"] Pop() - Pops out (removes) one element from the end of an array var data = ["A","B","C"]; data.pop(); Result data = ["A","B"]; Unshift() - Adds one or more elements to the beginning of an array var data = [ "A" ]; data.unshift( "B","X" ); data.unshift( "C" ); Result data = ["C","B","X","A"] Shift() - Removes one element from the beginning of an array var data = ["A","B","C"]; data.shift(); Result data = ["B","C"]; Splice() - Removes elements specified number of items from the starting index and also op
Continue Reading by clicking here >>