I'm trying to download an .xlsx file from the eia and getting the following error. The error is: "Error: ZipException (Java): invalid entry size (expected 2385 but got 2390 bytes)" I have tried ...

I'm creating a utility to import data from Excel to Oracle database, I have a fixed template for the excel file, Now, when I'm trying to import the data by Jet provider and ADO.Net - Ole connection...

I have a partial code to import excel into Python as strings. How I can exclude first row when importing data from excel into Python? import pandas as pd data = pd.read_excel(".xlsx", parse_cols="...

I tried to import an excel file which is not within the same folder than the script. I need to get one folder above, then into another folder (B_folder) and there is file 2_file.xlsx I tried...

How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task? Column headers would be sanitized to column names. Datatype...

I am importing excel worksheets to a datagridview using the following code: Private Sub Browsimportbtn_Click(sender As Object, e As EventArgs) Handles Browsimportbtn.Click Dim textpath As String ...

Reading Excel files into Python often means tripping over the Excel leap year issue. This is described in many posts, but none offer a convenient solution. So this is what I'm asking here. With cod...

I have a set of data as input to be given to MongoDB in XLSX format. How am I supposed to import the Excel file as input to MongoDB? Is there any plugin available to import xlsx files as inp...

I created a function to check the file extension of and imported Excel file. I have run same source on 2 different PCs. PC-1 Configuration: Win 7 64bit XAMPP with PHP 7.0.x Browser Google Chrom...

I used the spreadsheet gem to do this. It works but it can be very slow at times .I even tried the Roo gem, but that didn't improve the performance. Is there a better way to do this job? The weird ...

I have an Excel file with a large set of data. The built-in graphs available in Excel are not enough to analyze these data, so I am thinking about using some tool like octave or R. I was thinking ...

Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the...

I am trying to use Python Pandas to import a CSV file. The example data in this file is as follows where the first row is the column names separated by commas. End Customer Organization ID,End Cus...

The problem is pretty simple. Every week I receive a bunch of password protected excel files. I have to parse through them and write certain parts to a new file using Python. I am given the passwor...

I've seen lots of references to converting the "date" portion of the Excel serial date format, but everyone seems to skip the "time" portion of it. Here is what I need to do: I have an Excel file...

Been investigating for a while now and keep hitting a brick wall. I am importing from xls files into temp tables via the OpenRowset command. Now I have a problem where I’m trying to import a certai...

I use cloud9 ide to use ruby on rails! I'm testing the gem 'roo' to bring excel file to my DB. before I do it, I wanted to test this gem work. gem doc : https://github.com/roo-rb/roo but there i...

I was trying to read an excel spreadsheet into R data frame. However, some of the columns have formulas or are linked to other external spreadsheets. Whenever I read the spreadsheet into R, there a...

I want to import data from an Excel file - assume Excel 2003 / .xls - to Sql Server 2008. Have tried adding a linked server to the JET OLE DB Access driver, and of course it fails on the 64-bit ma...

I am writing a C# library to read in Excel files (both xls and xlsx) and I'm coming across an issue. Exactly the same as what was expressed in this question, if my Excel file has a column that has...

When importing data from a text file (csv) into MS Access, I get an error "Type conversion failure" for 1 field. The field has data with date format "yyyy-mm-dd hh:nn:ss" and Access simply refuses ...

I have an excel file produced automatically with occasional very large numbers like 135061808695. In the excel file when you click on the cell it shows the full number 135061808695 however visually...

I'm trying to read a 17MB excel file (2003) with PHPExcel1.7.3c, but it crushes already while loading the file, after exceeding the 120 seconds limit I have. Is there another library that can do it...

I am trying to convert the .xlsx file http://www.eia.gov/forecasts/steo/archives/mar14_base.xlsx into a .csv, but it seems that the .xlsx contains formulae that link to a local file that I don't ha...

I've used RODBC for some time to import Excel spreadsheets with mostly good results. However I have had no luck writing to an Excel spreadsheet. Also are there favorable differences using the xlsx ...