Any programming language library to parse Excel data is generally larger, slower and complicated.In data-warehouse, CSV follows a fairly flat, simple schema.In data-warehouse, Excel is preferable for detailed standardized schema specification.CSV files can be opened or edited by text editors like notepad.Files saved in excel cannot be opened or edited by text editors.CSV is a format for saving tabular information into a delimited text file with extension.Excel is a spreadsheet that saves files into its own proprietary format viz xls or xlsx.A CSV file is just a text file, it stores data but does not contain formatting, formulas, macros, etc.An Excel not only stores data but can also do operations on the data.It is a plain text format with a series of values separated by commas CSV stands for Comma Separated Values. It is a binary file that holds information about all the worksheets in a workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |