PDA

View Full Version : How to insert active rows from excel to SQL



vinexcel
2019-02-24, 11:47 PM
Hi All,

I am working on a template to insert the data from excel to SQL Server.
Based on the Frequency Excel sheet will hide the column. example . When i select frequency 6 then only 6 rows will be available in the sheet and other rows will be hidden.
when i am updating the column all the rows in the sheet got inserted in the DB.

My requirement is to insert only 6 rows.

Please let me know the solution.
Thanks in advance.