Solved

Regular expression search and grab info from excel

Posted on 2010-09-08
2
254 Views
Last Modified: 2012-05-10
Hello,

I have an excel file that I need to upload and grab the total line's from, see attached file.

I really need each field in the total line as its own var if possible.

Any thoughts?
demo-file.xlsx
0
Comment
Question by:vrmetro
2 Comments
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 33630292
Where does this file come from?  Can you get it in a CSV format instead of the XLSX format?
0
 

Author Closing Comment

by:vrmetro
ID: 33630582
After further discussion simply grabbing the total will not fit the bill, we're going to csv up to mysql then play with the data from there.  Thanks though Ray!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now