Click here to Skip to main content
15,917,795 members
Home / Discussions / C#
   

C#

 
QuestionSerialize/Deserialize data class from different assemblies Pin
charian092026-May-09 19:29
charian092026-May-09 19:29 
AnswerRe: Serialize/Deserialize data class from different assemblies Pin
occcy26-May-09 20:58
occcy26-May-09 20:58 
GeneralRe: Serialize/Deserialize data class from different assemblies Pin
charian092026-May-09 23:44
charian092026-May-09 23:44 
AnswerRe: Serialize/Deserialize data class from different assemblies Pin
Giorgi Dalakishvili27-May-09 1:21
mentorGiorgi Dalakishvili27-May-09 1:21 
QuestionInformation obut BHO? Pin
Yukivi26-May-09 19:19
Yukivi26-May-09 19:19 
AnswerRe: Information obut BHO? Pin
Henry Minute27-May-09 0:49
Henry Minute27-May-09 0:49 
QuestionEDB file using C# Pin
vijaywithu26-May-09 19:10
vijaywithu26-May-09 19:10 
AnswerRe: EDB file using C# Pin
Colin Angus Mackay26-May-09 21:00
Colin Angus Mackay26-May-09 21:00 
GeneralRe: EDB file using C# Pin
vijaywithu26-May-09 23:02
vijaywithu26-May-09 23:02 
QuestionI want to use FoxPro DBF file Pin
M Riaz Bashir26-May-09 18:46
M Riaz Bashir26-May-09 18:46 
AnswerRe: I want to use FoxPro DBF file Pin
Mycroft Holmes26-May-09 19:47
professionalMycroft Holmes26-May-09 19:47 
GeneralRe: I want to use FoxPro DBF file Pin
M Riaz Bashir26-May-09 20:00
M Riaz Bashir26-May-09 20:00 
AnswerRe: I want to use FoxPro DBF file Pin
leung wilson26-May-09 21:06
leung wilson26-May-09 21:06 
QuestionDownloading all files in directory FTP C# Pin
jumbojs26-May-09 17:05
jumbojs26-May-09 17:05 
AnswerRe: Downloading all files in directory FTP C# Pin
Anubhava Dimri26-May-09 18:43
Anubhava Dimri26-May-09 18:43 
AnswerRe: Downloading all files in directory FTP C# Pin
stancrm26-May-09 20:45
stancrm26-May-09 20:45 
Questiondatagridtextbox column text changed event problem Pin
Shuaib wasif khan26-May-09 11:45
Shuaib wasif khan26-May-09 11:45 
AnswerRe: datagridtextbox column text changed event problem Pin
Henry Minute26-May-09 12:19
Henry Minute26-May-09 12:19 
GeneralRe: datagridtextbox column text changed event problem Pin
Shuaib wasif khan26-May-09 12:30
Shuaib wasif khan26-May-09 12:30 
AnswerRe: datagridtextbox column text changed event problem Pin
jaypatel51227-May-09 0:32
jaypatel51227-May-09 0:32 
QuestionNeed suggestion on getting column data from excel without using ADO or Excel Interops Pin
DeepToot26-May-09 10:29
DeepToot26-May-09 10:29 
AnswerRe: Need suggestion on getting column data from excel without using ADO or Excel Interops Pin
Dave Kreskowiak26-May-09 16:21
mveDave Kreskowiak26-May-09 16:21 
GeneralRe: Need suggestion on getting column data from excel without using ADO or Excel Interops Pin
DeepToot27-May-09 8:12
DeepToot27-May-09 8:12 
Thanks Dave for the response.



Dave Kreskowiak wrote:
Since you're shot down the two programmatic methods of doing this, you're left with starting Excel and typing everything in yourself.


Ok well that answered the bulk of my questions - have you ever ran up against the Data of a column being F3, F2 and such and Office thinking its a float and setting its datatype of the column to Decimal (int32 would of been fine..but not decimal)?



Dave Kreskowiak wrote:
That limit is also imposed by most versions of Excel, not just ADO.

Right, actually going back and reading my post you could actually replace ADO with Excel.


Dave Kreskowiak wrote:
Then you need to use quotes around the value in your CSV to force a string type.


I agree this would be a solution, however, the application we are developing is for pivoting of data on a pivotGrid doing aggregates and we cannot assume string if we need it to be an integer.


Dave Kreskowiak wrote:
You don't have any other options. Those are the two programmatic methods you have of talking to Excel.


Well, that is unless you're using Excel 2007 which doesn't have the 255 column limit and now uses a completely different file format allowing you much greater control over creating a workbook, since it's based mostly on an XML format.


Yea I knew that but client's won't upgrade to 07 till later. I'm stuck with 03.



Dave Kreskowiak wrote:

Why does it appear that you're using Excel as a database, something that it is very poor at doing??


Were not. Client drops a csv file onto the pivotGrid, we import that data into the pivotGrid and in doing so we needed to make sure that the columns are setup correctly (ie.minus the F3 float bug).

The first round I was grabbing the data using strictly ado..Stopped using ado because of the way it determines DataTypes on columns..then moved to a csv parser using StreamReader but then lost our dataTypes. So now im researching other alternatives but there doesn't seem to be any.

I do appreciate your response and time Dave. I understand I'm stuck with what I have now. I'll keep trying other idea's.

Enjoy your afternoon.
GeneralRe: Need suggestion on getting column data from excel without using ADO or Excel Interops Pin
Dave Kreskowiak27-May-09 12:01
mveDave Kreskowiak27-May-09 12:01 
QuestionTo Henry Minute, Original Griff, fly904, stancrm, Computafreak, Guffa, DaveyM69, J4amieC, Tom Deketelaere and Dave Kreskowiak Pin
Rajdeep.NET is BACK26-May-09 8:14
Rajdeep.NET is BACK26-May-09 8:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.