csv文件（CSV file）

csv文件（CSV file） csv文件(CSV file) CSV file profile , 04 2009, 12:26 on Tuesday, 21 We must be puzzled to see this topic. What's the relationship between this CSV file and office?. Ha ha, careful friends in the use of Excel will find, Excel can save as CSV format. I didn't know anything about it before, but just knew that excel could save it as a file. Yesterday, a sad thing brought me to the CSV file. Yesterday morning, when the manager of the finance department left his cell phone in the taxi when he was running for the bus, I had only sympathy for him. As a result, I was not only sympathetic, but also helping him share the pain. Financial department manager asked me to help him before the Excel to do with the mail list to get mobile phone, my gosh, more than 350 ah, manual input to lose to God knows how long ah. Fortunately, there is a mobile phone Nokia PC Suite can support text from the CSV file, I first built a mobile phone mail list export CSV file, use a text editor to open and then looked at the Nokia format for the text is what, then excel the mail list set into a kind of format, the other save as CSV file, and then imported into the mobile phone. No, it's 5 minutes. Ha-ha。 The efficiency of the computer is so high, but there are good tools, but also an expert, know how to use ah, by the way to exaggerate their own. Let's introduce the CSV file below: The so-called "CSV" is the abbreviation of Comma Separated Value (comma separated value), and is usually a plain text file. Here is a part of the actual CSV file, so that everyone has a sensitive understanding of him. We selected the Sjojo_Rescan file for CSV (Sjojo is one of the members of the ASW- Asia wind map). Sj_mino1001.jpg, 715282,4FB55FE8, Sj_mino1002.jpg, 47128993203C5C, Sj_mino1003.jpg, 451929, C4E80467, Usually at the beginning of the file CSV is not blank, in units of a picture recorded in each row of a number of data, each data using commas to separate (standard English comma). In general, the format of the.CSV file used in the set diagram is this: File name, file size (in bytes), CRC checksum, comment (omitted) Sj_mino1001.jpg, 715282,4FB55FE8, | | | | File name, file size, CRC value, comment (omitted) If your machine is loaded with Microsoft Excel, the.Csv file is opened by default by Excel. Note that when you double-click a.CSV file, Excel open it later even without any modification, Excel often prompted to correct file format in the closed time, this time do not remember to choose "". Because Excel thinks the numbers in the.CSV file are represented by scientific notation, and the numbers we want in the.CSV file are common. If you choose "yes", Excel You can count all the numbers in the CSV file in a scientific way (2.54932E+5), and this file won't work. So, if most of your CSV files are used on the set diagram, it is recommended to change the default opening of.CSV to any text editor, and the Notepad comes with a good choice. OK, let's go back to the format of the CSV file. See above, from left to right, sj_mino1001.jpg is the file name, and 715282 is the file size represented by bytes. When the name of the file contains commas, because the comma plays a special role in the CSV file, in order to avoid ambiguity, it is necessary to enclose the file name in quotation marks. For example, "The, Art, Fantasy.jpg", 384211,...... followed by a 8 bit 16 digit number 4FB55FE8, which is the CRC32 checksum of the file. The essence of the entire CSV file is here. The general mail handler has the function of importing and exporting address books, and the import and export address book functions are implemented through CSV and Wab files. For example, most people use OE and Foxmail, and their address book contents can be exported as.CSV files, which can be opened not only by Excel, but also by any text editing software. CSV files can be imported quickly by OE and Foxmail, and the file is small and easy to carry with floppy disks. You can export a *.CSV address book file from OE as a template, and the *.CSV address book format consists of items such as name, e-mail address, and post. Intended readers can use Notepad to open the CSV file to see that CSV is a comma delimited file. If you only use it to send e-mail, you can enter only the "name" and "e-mail address" these two items can be. Each of the contacts contains one line, each line separated by "" "", and no "," number at the end of the last item. Blank does not enter the content, but the delimiter "," not. Thus, on the basis of boilerplate files, as soon as new contacts are added to the address book, several contacts are added as long as they are added directly at the end of the text file. With a large number of new contacts added to the address book, this editing method saves more typing effort. Modify the *.CSV file that contains contact information. You simply import the contents of the *.CSV file into the address book at OE or Foxmail. This *.CSV text file has a small capacity. As far as generality is concerned, CSV files are better than Wab files! Therefore, in the backup and restore communications record, or use CSV file is better Notice that the CSV file is virtually different from the text file, except that its contents are separated by default, and the system is opened by default with Excel