Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
hi
 
i need to export some values from database to excel which has some bit field
 
during export i need to export the bit fields as checkbox so that user can make some changes in the excel file and upload back to the database
 
export to excel happens in the following ways
 
1. search for the details
2. Click export excel (based on search)
3. then user can change some fields and then upload the data
 

any one help me how to create checkbox inside the excel while export
Posted 11-Feb-13 2:23am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I don't get it (your idea)! If i understand you well, the process looks like: Database -> Export some data to Excel -> User can edit / remove data -> Import data from Excel to database. How would you protect the integrity of data? Don't you see it's bad idea?
 
Better way is to write custom application. If you stuck, post new question and we'll help you.
  Permalink  
Comments
cscManoj22 at 11-Feb-13 9:21am
   
hi it is happening in application only we have one search screen and use will some search the data and result will be populated to datagrid from there we introduce one option to export excel from there he will update some data and get back to database
Maciej Los at 11-Feb-13 9:28am
   
As i wrote before: this is bad idea!
How would you protect the integrity of data???
cscManoj22 at 12-Feb-13 10:49am
   
hi it is an internal site so integrity will not lost
 
can i have a solution please
Maciej Los at 12-Feb-13 10:57am
   
I'll try, but which part?
1. search for the details
2. Click export excel (based on search)
3. then user can change some fields and then upload the data
I believe you know how to do task 1 and 2. I can only help you to add checkboxes via code into excel sheet. OK?
cscManoj22 at 12-Feb-13 11:11am
   
ys absolutely 3rd one i just explained three steps of how excel is going to exported

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



Advertise | Privacy | Mobile
Web04 | 2.8.140926.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100