Top "Import-from-excel" questions

Information taken from Microsoft Excel and imported in to another system

How do I read an Excel file into Python using xlrd? Can it read newer Office formats?

My issue is below but would be interested comments from anyone with experience with xlrd. I just found xlrd and …

python xlrd import-from-excel
Reading large excel file with PHP

I'm trying to read a 17MB excel file (2003) with PHPExcel1.7.3c, but it crushes already while loading the file, after …

php excel performance large-files import-from-excel
How to open an Excel file in PHP?

How can an excel file be opened, all cols/rows read in an array etc the same way .csv files …

php import-from-excel
Loading data from Excel file into R or Octave

I have an Excel file with a large set of data. The built-in graphs available in Excel are not enough …

excel r octave import-from-excel
How to read excel Unicode characters using Python

I am receiving an Excel file whose content I cannot influence. It contains some Unicode characters like "á" or "é". My code …

python unicode import-from-excel liclipse
Import Data Wizard Does Not Like Data Type I Choose For A Column

Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column …

sql-server-2005 ssis import-from-excel
Missing Microsoft Excel as option in SQL Server data import tool

I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2. I don't have MS Office installed. I now notice that …

sql-server-2012 64-bit excel-2007 import-from-excel windows-server-2012-r2
R - Import & Merge Multiple Excel Files And Add Filesource Variable

I have used R for various things over the past year but due to the number of packages and functions …

r excel import merge import-from-excel
Using Column headers to parse excel sheets using roo - Ruby

Can we use column headers to specify the column number from which we are parsing the excel sheet using roo …

ruby-on-rails ruby import-from-excel ruby-roo
To convert Excel into CSV efficiently in ruby

I used the spreadsheet gem to do this. It works but it can be very slow at times .I even …

ruby-on-rails ruby export-to-csv import-from-excel