import-from-excel
how to import excel file (XLSX) to mongoDB [closed]
You cannot import an XLSX file into MongoDB directly. However, what you can do with an Excel spreadsheet is save it as a CSV file, then use mongoimport to import it into MongoDB. You can find the documentation for mongoimport here, but in any case, the command you need to run should look something like … Read more
Could not load file or assembly ‘Office, Version=15.0.0.0’
I also got this error message even if I have Office 2010 and I don’t have Microsoft.Office.Interop.Excel folder under GAC. I found the solution for my case here: https://www.add-in-express.com/forum/read.php?FID=5&TID=15525 You have to reference two dll-files from these folders: C:\Windows\assembly\GAC_MSIL\Microsoft.Vbe.Interop\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll and C:\Windows\assembly\GAC_MSIL\office\15.0.0.0__71e9bce111e9429c\OFFICE.DLL
Reading Excel file using node.js
There are a few different libraries doing parsing of Excel files (.xlsx). I will list two projects I find interesting and worth looking into. Node-xlsx Excel parser and builder. It’s kind of a wrapper for a popular project JS-XLSX, which is a pure javascript implementation from the Office Open XML spec. node-xlsx project page Example … Read more
How to export data from Excel spreadsheet to Sql Server 2008 table
From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data. This opens the Import Data Wizard, which typically works pretty well for importing from Excel. You can pick an Excel file, pick what worksheet to … Read more
From Excel to DataTable in C# with Open XML
I think this should do what you’re asking. The other function is there just to deal with if you have shared strings, which I assume you do in your column headers. Not sure this is perfect, but I hope it helps. static void Main(string[] args) { DataTable dt = new DataTable(); using (SpreadsheetDocument spreadSheetDocument = … Read more
Faster way to read Excel files to pandas dataframe
As others have suggested, csv reading is faster. So if you are on windows and have Excel, you could call a vbscript to convert the Excel to csv and then read the csv. I tried the script below and it took about 30 seconds. # create a list with sheet numbers you want to process … Read more
Text was truncated or one or more characters had no match in the target code page When importing from Excel file
I assume you’re trying to import this using an Excel Source in the SSIS dialog? If so, the problem is probably that SSIS samples some number of rows at the beginning of your spreadsheet when it creates the Excel source. If on the [ShortDescription] column it doesn’t notice anything too large, it will default to … Read more
Reading an Excel file in PHP [closed]
You have 2 choices as far as I know: Spreadsheet_Excel_Reader, which knows the Office 2003 binary format PHPExcel, which knows both Office 2003 as well as Excel 2007 (XML). (Follow the link, and you’ll see they upgraded this library to PHPSpreadSheet) PHPExcel uses Spreadsheet_Excel_Reader for the Office 2003 format. Update: I once had to read … Read more
Excel “External table is not in the expected format.”
“External table is not in the expected format.” typically occurs when trying to use an Excel 2007 file with a connection string that uses: Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0 Using the following connection string seems to fix most problems. public static string path = @”C:\src\RedirectApplication\RedirectApplication\301s.xlsx”; public static string connStr = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + path + … Read more