 |  |  |  |  |  |  |  |
transfer contends from database table to excel
Please support our C# advertiser: Intel Parallel Studio Home
 |
•
•
Join Date: Dec 2007
Posts: 205
Reputation: 
Solved Threads: 11
Posting Whiz in Training
hi,
i want to transfer the contends of a table from database to excel. can i declare a excel sheet in c#
i want to transfer the contends of a table from database to excel. can i declare a excel sheet in c#
Have an ask of google. Google knows the answers
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 205
Reputation:
Solved Threads: 11
Posting Whiz in Training
done dat. am able to do it now. but i want the column names also. Is that possible?
f you need to putput it, and keep the names, put the names into an array you can output as a header line.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 205
Reputation:
Solved Threads: 11
Posting Whiz in Training
Also if i want to save it somewhere of my wish what would the code be like. i have defined a workbook also populated the values. now while saving it is saving in the same place where project is created. i want to save it in some other place. my code is
wb.SaveAs(FileName,Excel.XlFileFormat.xlWorkbookNormal,
null,null,false,false,Excel.XlSaveAsAccessMode.xlShared,
false,false,null,null,null);
what changes do i make?
wb.SaveAs(FileName,Excel.XlFileFormat.xlWorkbookNormal,
null,null,false,false,Excel.XlSaveAsAccessMode.xlShared,
false,false,null,null,null);
what changes do i make?
Change the filename.. or is there some hidden part to that question
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 205
Reputation:
Solved Threads: 11
Posting Whiz in Training
C# Syntax (Toggle Plain Text)
this is my code ? can you suggest any solution
Now you really are being stupid
the contents of "Filename" has to be what you wanted..
the contents of "Filename" has to be what you wanted..
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 205
Reputation:
Solved Threads: 11
Posting Whiz in Training
The contents of "Filename" that i can provide is just the any name for the file, not like "C:\....". it is getting saved in my documents folder.
Please give a proper solution
Please give a proper solution
Sorry, but you are being stupid,
Put the path in your filename, and it will be saved where you tell it..... If you dont it would be saved in whats the "current directory"
Put the path in your filename, and it will be saved where you tell it..... If you dont it would be saved in whats the "current directory"
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
|
Other Threads in the C# Forum
- Previous Thread: converting VB to C sharp for Quality Center
- Next Thread: Loading Database data into Labels for viewing?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm alignment app array barchart bitmap box broadcast c# c#gridviewcolumn cast check checkbox client combobox communication control conversion csharp custom database datagrid datagridview dataset datatable datetime degrees development draganddrop drawing elevated encryption enum excel file focus form format forms function gdi+ hospitalmanagementsystem httpwebrequest image index input install java label list listbox localization login mandelbrot math messagebox mouseclick mysql operator path photoshop picturebox pixelinversion plotting pointer post programming radians read regex remote remoting richtextbox server sleep socket sql statistics stream string stringformatting sun table text textbox thread time timer update usercontrol validation visualstudio webbrowser whileloop windows winforms wpf xml
