how to convert excel to .php files

Question

1.00/5 (3 votes)

See more:

C++

Posted 23-May-11 21:15pm

wisrael

Add a Solution

Comments

Joan M 24-May-11 3:24am

well... excel has a propietary format and allows you to make tons of things... PHP is a "programming language" that allows you to do several other things... your question therefore has not a lot of sense... I guess you are asking how to represent excel data in PHP pages... but you definitely should explain a little bit more your question...

wisrael 2-Jun-11 6:54am

thanks for your concern firstly.the question is : gain data from excel file,then convert to some mode .php file; like this: if excel "country" field is "Taiwan",so .php file to be --set("entry:84/country", "Taiwan");

Joan M 2-Jun-11 7:04am

Read my new answer...

wisrael 2-Jun-11 7:36am

expecting...

Joan M 2-Jun-11 7:42am

Already answered... See solution 2. ;)

wisrael 2-Jun-11 7:47am

reading excel file is ok,but writeing to be .php file have some exception..

Joan M 2-Jun-11 8:04am

So your problem is to write in a PHP file? you should do it as in any text file... if that is the problem I would recommend you to post a new question explaining that. and we will help! this is easy for sure... take a look at fopen, fwrite... this will help to start.

wisrael 2-Jun-11 8:21am

excel data/records can partly be written to php file,but some records are exceptional.

wisrael 2-Jun-11 8:45am

pHpFile = fopen("f:\\exctophp.php" ,"w");

strcpy(buf, lineValue.GetBuffer(0));
fwrite(buf, 1, lineValue.GetLength(), pHpFile);

wisrael 2-Jun-11 9:13am

if the excel file is just yours,how will you write to be php file as above mode ..

Joan M 2-Jun-11 9:34am

yes, of course something similar to that... but, if you have problems implementing this, you should post another question and everybody will be able to see it and answer it...

wisrael 2-Jun-11 21:53pm

good idea.i will.but i insist that i can acquire answers from you yet,give me five..

Joan M 3-Jun-11 0:40am

You should do that, here is plenty of people much more capable than me... Make a new question and someone will help... Today I'll be all day out so I'll won't be able to help you.

wisrael 3-Jun-11 0:46am

already,thank you all the same..

Sergey Alexandrovich Kryukov 24-May-11 3:24am

Strange idea... Do you think they have enough in common? Think again. Why C++. Convert Excel to PHP using C++ ? :-)
--SA

wisrael 2-Jun-11 6:55am

if do not use C++ ,any other ways?

Sergey Alexandrovich Kryukov 2-Jun-11 13:22pm

No! You do use C++! You claim so in the tag of your question!
How come you are trying to get help from people you mislead so much?!
What do you want to use for conversion? But don't rush to answer -- you did not provide any requirements. What is expected to be done in conversion (mapping rules)?
--SA

wisrael 2-Jun-11 21:47pm

perhaps,c++ is not the only way to implement it.requirements are that get data/records from excel,then convert to php file following some mode,for example,the excel file "country" field is "Taiwan",so the php file to be---set("entry:84/country", "Taiwan");

Sergey Alexandrovich Kryukov 2-Jun-11 22:30pm

Of course it is not. I only discuss what you want to achieve; you don't inform use, really.
--SA

wisrael 2-Jun-11 22:51pm

i have already explain clearly,just implement the conversion from excel to php mode

Sergey Alexandrovich Kryukov 3-Jun-11 0:36am

You explained nothing! There is no one-to-one correspondence between the two, so there is not "conversion" in principle. You need to pieces of meta-data: input, output schema and mapping. Where do you have it? What's the implementation language? You still have "C++" in your question tag and told me the you do not use C++. Where is the truth?

Look at the votes for your question. You got 3 votes of "1", only one of the votes is mine. How do you think why? Because you explain nothing and probably do not understand the problem yourself.
Sorry, it needs real specification to discuss any further.

Do you have a solution already, by the way?
--SA

wisrael 3-Jun-11 0:42am

think one more time,perhaps ,you can get it..

Sergey Alexandrovich Kryukov 3-Jun-11 1:55am

No. Stop telling something that is not true. I don't invite you to think again though; probably all possibilities are exhausted.
You being so persistent in not answering, but who loses? I lost some of my time though, but you cannot get any answer, can you?
Keep being cryptic...
--SA

wisrael 3-Jun-11 3:45am

no better ways to describe it clearly than as above,but thank you sincerely..

wisrael 3-Jun-11 3:46am

no better way to describe it clearly than as above,but thank you sincerely

2 solutions

Solution 1

I don't think you meant what you asked: did you mean "how do I read excel files in php"?

If so, then Google can help, or look here: Reading and Writing Spreadsheets with PHP[^]

Posted 23-May-11 21:27pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Joan M · Accepted Answer · 2011-06-02T01:08:00

This answer comes as an answer of your comment.

Take a look at these links:

Accessing Excel Spreadsheets via C++[^]

Reading Excel files using ODBC[^]

How to Read and Write Excel Files in C++ via ADO[^]

There are lots of ways to interact with excel, if you have to do it in C++ then the way to go is to read the values in the excel file, open a text file in order to write data into it and translate the excel file as you need to store the values into the text file... you know your requirements so you will have to finish your design to implement your needs, but basically you have to reach access to the excel file, open a text file and store data inside to follow the php requirements.

Hope this helps!

how to convert excel to .php files

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us