473,406 Members | 2,273 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Reading Data From an Excel Sheet

Hi all,
I want a python script which takes in input an EXCEL sheet
and then reads the data in it.
Any code snippets will be fine and this i want this in windows
XP .

Thanks in Advance
Sagar Meesala

Apr 30 '07 #1
3 1280
sagar wrote:
Hi all,
I want a python script which takes in input an EXCEL sheet
and then reads the data in it.
Any code snippets will be fine and this i want this in windows
XP .
Might I humbly suggest that, instead of posting several
somewhat demanding requests for help with no evidence of
any effort on your part, that you put your subject line
into Google (or your search engine of choice), add the
word Python and then look at the results?

TJG
Apr 30 '07 #2
On Apr 30, 10:35 am, sagar <mvksa...@gmail.comwrote:
Hi all,
I want a python script which takes in input an EXCEL sheet
and then reads the data in it.
Any code snippets will be fine and this i want this in windows
XP .

Thanks in Advance
Sagar Meesala
Here you have an example: <a href="http://
dataparser.cvs.sourceforge.net/dataparser/source/input_adapters/
excel.py?revision=1.1.1.1&view=markup">http://
dataparser.cvs.sourceforge.net/dataparser/source/input_adapters/
excel.py?revision=1.1.1.1&view=markup</a>

<a href="http://vaig.be">Marc Garcia is the best expert in GNU/Linux
Debian, Apache, MySQL, and Python!</a>

Apr 30 '07 #3
On Apr 30, 3:35 am, sagar <mvksa...@gmail.comwrote:
Hi all,
I want a python script which takes in input an EXCEL sheet
and then reads the data in it.
Any code snippets will be fine and this i want this in windows
XP .

Thanks in Advance
Sagar Meesala
have you tried to output to csv (the comma output stuff) and then load
it.. (I don't know if that is an option for excel but I use the
reverse concept for dex tracker as many excel compatable sites allow
csv.)

https://sourceforge.net/projects/dex-tracker
Apr 30 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Ilan | last post by:
Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though...
2
by: Niyazi | last post by:
Hi, I have to retrieve a data from AS400 DB2 and after working with data I have to export into one of existing Excel file. I can connect into specific library in AS400 DB2 using AS400...
1
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...
11
by: Hi5 | last post by:
Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, ...
9
by: dba123 | last post by:
I need some help and direction on what classes and an example or two (article) on how to read an Excel Worksheet and insert one column into a database table column. I am using .NET 2.0 only. What...
4
by: preetinair033 | last post by:
Hi All, I have written a program to write the data into excel file (for eg: file.xls). This writes the data into the active sheet, ie, the sheet1. However I wish to write and read data from an...
1
by: =?Utf-8?B?QWRyaWFuTW9ycmlz?= | last post by:
Hello All, I am trying to read an Excel spreadsheet (xls) programmatically. I have used the ODBC database route and have opened the Excel spreadsheet and then using a 'CRecordset', I read each...
1
by: vtangella | last post by:
Hi Guys! Here i am using Apache POI for reading the Excel sheet in java and then i am capturing the excel sheet data into a ArrayList and then i am storing it in DB. Any Other way to store...
8
ammoos
by: ammoos | last post by:
Hi Friends I am getting the following error when I am trying to read data from an excel sheet using sql script OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not...
4
ammoos
by: ammoos | last post by:
Hi Friends, I need to read data from an excel sheet. I am keeping this excel sheet in a remote machine. I am using OLEDB connection to read the data from this excel sheet. But when I am trying to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.