help_lucky Posted June 2, 2010 Share Posted June 2, 2010 1 I have a requirement in which, i need to upload an excel file into SQL Server database. It is working well till this point. But sometimes i am getting excel file in such a way, that the first 2 rows and columns are empty rows. That is not even fixed every time. so the format of the table after upload is not as expected. It is assigning F1, F2 as column names for the table in SQL Server. It varies from file to file. I want to program it in such away so that the user can enter the row number and the column number from where the actual data is starting. So that while upload it should from line 3 and column 2. I don't know how to specify that row and column while uploading. Please help me to solve the same. Quote Link to comment https://forums.phpfreaks.com/topic/203607-php-sql-server-excel-file-upload-from-a-specific-row/ Share on other sites More sharing options...
dabaR Posted June 3, 2010 Share Posted June 3, 2010 Are you saying that you have a PHP script that basically takes an excel file, and loads it into mssql as a new table with all the columns and rows from the excel file? Quote Link to comment https://forums.phpfreaks.com/topic/203607-php-sql-server-excel-file-upload-from-a-specific-row/#findComment-1067017 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.