How to validate Excel sheet column names with SQL- table col

Question

I have an Excel sheet which contains 5 columns (Name,EmpNo,Adress,PhNo,MobNo) and I have SQL Table which contains 5 columns with same names as mentioned above, so now I need to validate excel sheet againist DB Table columns before its getting uploaded, Here I need to do this validation in CLIENT SIDE Script. Please help me how to do this

Sujeet Suman · Answer

Kumar please once try below link. This may resolve your second half problem: http://www.dreamincode.net/forums/topic/16506-mapping-of-column-name-in-excel-file-with-database-table/ http://stackoverflow.com/questions/30331520/how-to-fetch-the-only-column-data-from-excel-which-is-there-in-database-table-co

Manas Mohapatra · Answer

I hope that you are getting columns from excel sheet using javascript. Then problem is solved. Means you already know that what are columns present in your table. Suppose you have 5 columns in your table. Just check in javascript code that whether these columns are present in your excel sheet. If you get positive result then go ahead with excel sheet upload and insert data to server.

Sujeet Suman · Answer

Your most welcome Kumar. We are here to help each other only.

Sujeet Suman · Answer

Your most welcome Kumar. We are here to help each other only.

Sujeet Suman · Answer

Your most welcome Kumar. We are here to help each other only.

Sujeet Suman · Answer

Your most welcome Kumar. We are here to help each other only.

Kumar AU · Answer

Hi Sujeet, Thank you so much for your help, my issue is resolved.

Kumar AU · Answer

Hi Sujeet, Thank you so much for your help, my issue is resolved.

Kumar AU · Answer

Hi Sujeet, Thanks for your response. My question was different. anyway thanks for your time

Kumar AU · Answer

Thanks for your response Manas, your information resolved my half of my problem,but remaining part is how do I compare excel column name with Database table column name before I start inserting in JavaScript

Sujeet Suman · Answer

Kumar please once go through below link. This may help you:- http://www.codeproject.com/Articles/141811/Database-to-Excel-Spreadsheet

Manas Mohapatra · Answer

Please go though below links that will help you read data from excel sheet. Then you need to implement to check your column name inside the code. http://www.c-sharpcorner.com/code/1253/read-an-excel-file-with-javascript-without-activexobject.aspx http://stackoverflow.com/questions/16630413/how-can-i-read-an-excel-file-with-javascript-without-activexobject