Ideas:ġ.) I was thinking and making a solution with php en mysql, were the excel worksheet will be uploaded in xml format, so that a php script can run and read this xml file, so that it finally can be stored in a mysql database. detect that the thirth column is about Customernumbers and paste them in the Customernumber column in our worksheet. How can I detect what is written in every column and automatically cut and paste that column in the right column of our excel worksheet. We have to manualy cut and paste every column in our own excel sheet in the right order, so that our software can read everything and put it in the database (no not mysql, else i had made already a script for mysql). Sometimes they put Addresses in the first column, sometimes they put names in the first column. Also, the columns are not always in the same order. some people call the column with Customernumbers, numbers or pupilnumber. The problem is, not every customer sents us this information in the right order or with the same description, e.g. The first row contains the description of the columns, like: "Customernumbers", "Names", "Addresses" etcetera. the first column contains customernumbers, the second column contains names, the thirth column addresses etcetera. In this sheet, they put detailled information, organised in each column, e.g. On work we get excel sheets from our customers. I think it is easy to make this thing work, but I just don't know how to go further now.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |