Featured Articles
Announcing Pi
Technical Specifications
Raspberry Pi FAQs
Win a Pi
Raspberry Pi Wishlist
Actions
Forum Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 664 subscribers
  • Views 976 views
  • Users 0 members are here
Related

Raspberry pi read/write excel document on local network

l1t7l3ph0o7

Heres the scenario,

I'd like to write a program that helps keep track of specific tasks within an excel document located on network storage.

 

 

the excel file would contain 3 columns(Task#,Task amount, and Completed amount)

 

 

the way it would work is, a user would type in the task#

the raspberry would go down the first column looking for that task number

and then return the task amount from the same row.

 

 

then when a button is pressed, it would subtract 1 from the task amount column and add 1 to the completed amount column.

 

 

Does anyone know how to achieve this?

Or at least a few tutorials that Might help, I'm really new to y raspberry pi so any help would be very much appreciated.

  • 0

    One quick pointer

     

    I think you really mean a CSV file, if you are truly using an excel file for this your creating a bunch of un necessary effort for your self as the file format is quite complex

     

    A CSV file on the other hand that is often referred to as an excel file (But is simply an easy file for excel to read) is a plain old text file with commas separating the fields and a return to delimit the rows

     

    This would be very easy for almost any program to work with, especially on a Linux machine like a PI

  • 0 in reply to Robert Peter Oakes

    Thank you thats very useful, However  I need to pull information from an existing xlxs file that is edited multiple times a day by many different people. I suppose  I could create a script to create/write over existing  csv file from the relevant rows and columns every time its saved in excel. I think I can handle this bit, but I still need to figure out how to parse the Information, like searching the rows for a task number and then returning whatever value is in a specific column of the same row then writing to another specific column in that row. I think That is more specifically what I am looking for.

     

    Thank you, I'm glad you pointed that out to me; it's one more piece of the puzzle I was unaware of. I have heard of people using excel for data capture before but I didn't know what file formats were used.

     

    I'm hoping I can find some tutorials for something like this, I just need some examples to get started with.

  • 0 in reply to l1t7l3ph0o7

    I would probably have to make the pi save to a different csv file as it would be overwritten every time some edits the excel file, but that would work fine for my purpases.