Click here to Skip to main content
15,878,708 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:15
indian1435-Oct-17 3:15 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:25
mveRichard MacCutchan5-Oct-17 3:25 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:35
indian1435-Oct-17 3:35 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:51
mveRichard MacCutchan5-Oct-17 3:51 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Gerry Schmitz4-Oct-17 6:02
mveGerry Schmitz4-Oct-17 6:02 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table - able to achieve but a small issue still remaining Pin
indian1434-Oct-17 7:06
indian1434-Oct-17 7:06 
QuestionImprove the performance of the reading of Excel Files using interop Pin
indian1433-Oct-17 11:45
indian1433-Oct-17 11:45 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Dave Kreskowiak3-Oct-17 13:42
mveDave Kreskowiak3-Oct-17 13:42 
Office Interop = slow. There's no getting around that.

If you're using Excel 2007 or higher formats, like .xlsx, then you can use the OpenXML or ClosedXML SDK's. They will be much faster processing Excel sheets. The down side is there is a rather learning curve associated with using them.
System.ItDidntWorkException: Something didn't work as expected.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Gerry Schmitz4-Oct-17 5:37
mveGerry Schmitz4-Oct-17 5:37 
SuggestionRe: Improve the performance of the reading of Excel Files using interop Pin
Richard Deeming4-Oct-17 9:15
mveRichard Deeming4-Oct-17 9:15 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Patrice T7-Oct-17 15:43
mvePatrice T7-Oct-17 15:43 
QuestionArranging the box concept Pin
Member 1289648327-Sep-17 4:29
Member 1289648327-Sep-17 4:29 
AnswerRe: Arranging the box concept Pin
Pete O'Hanlon27-Sep-17 4:31
mvePete O'Hanlon27-Sep-17 4:31 
AnswerRe: Arranging the box concept Pin
Eddy Vluggen27-Sep-17 5:30
professionalEddy Vluggen27-Sep-17 5:30 
QuestionConverting 32 bit Excel Files to 64 bit Excel files Programatically Pin
indian14326-Sep-17 6:53
indian14326-Sep-17 6:53 
AnswerRe: Converting 32 bit Excel Files to 64 bit Excel files Programatically Pin
Richard Deeming26-Sep-17 7:28
mveRichard Deeming26-Sep-17 7:28 
QuestionNeed to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
indian14321-Sep-17 10:18
indian14321-Sep-17 10:18 
AnswerRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Gerry Schmitz21-Sep-17 12:44
mveGerry Schmitz21-Sep-17 12:44 
GeneralRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Peter R. Fletcher14-Oct-17 11:24
Peter R. Fletcher14-Oct-17 11:24 
QuestionConvert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 1:40
chr1s211-Sep-17 1:40 
AnswerRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming1-Sep-17 2:34
mveRichard Deeming1-Sep-17 2:34 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 4:07
chr1s211-Sep-17 4:07 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell18-Sep-17 12:24
jschell18-Sep-17 12:24 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming19-Sep-17 1:35
mveRichard Deeming19-Sep-17 1:35 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell20-Sep-17 5:08
jschell20-Sep-17 5:08 

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.