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

.NET (Core and Framework)

 
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 
They're not 32-/64-bit files. The .xls files are old-style Excel 2003 files, and the .xlsx files are the newer Excel 2007 / OpenXML files.

If you're writing an interactive desktop application which will be run on a computer with Office 2007 or later installed, you could use Interop to convert the files:
C#
var app = new Microsoft.Office.Interop.Excel.Application();
var wb = app.Workbooks.Open(sourceFilePath);
wb.SaveAs(Filename: destinationFilePath, FileFormat: Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook);
wb.Close();
app.Quit();

Otherwise, you'll need to use a library which supports both formats - for example, NPOI[^]. It's not trivial, but this StackOverflow answer[^] has an example.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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 
QuestionCannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 19:32
Member 1150681831-Aug-17 19:32 
AnswerRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Richard MacCutchan31-Aug-17 20:56
mveRichard MacCutchan31-Aug-17 20:56 
GeneralRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 21:35
Member 1150681831-Aug-17 21:35 
Questionis not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
indian14329-Aug-17 13:41
indian14329-Aug-17 13:41 
GeneralRe: is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
PIEBALDconsult29-Aug-17 13:49
mvePIEBALDconsult29-Aug-17 13:49 
AnswerRe: is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
Richard MacCutchan29-Aug-17 20:52
mveRichard MacCutchan29-Aug-17 20:52 
Questionpie chart report in vb.net Pin
Member 1338013327-Aug-17 1:21
Member 1338013327-Aug-17 1:21 
AnswerRe: pie chart report in vb.net Pin
debasish mishra23-Jan-18 20:38
professionaldebasish mishra23-Jan-18 20:38 

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.