Click here to Skip to main content
15,892,059 members
Home / Discussions / C#
   

C#

 
QuestionMouse event Handling [SOLVED] Pin
V.29-Jul-14 23:18
professionalV.29-Jul-14 23:18 
AnswerRe: Mouse event Handling Pin
OriginalGriff29-Jul-14 23:35
mveOriginalGriff29-Jul-14 23:35 
GeneralRe: Mouse event Handling Pin
V.29-Jul-14 23:39
professionalV.29-Jul-14 23:39 
AnswerRe: Mouse event Handling [SOLVED] Pin
Mycroft Holmes30-Jul-14 0:20
professionalMycroft Holmes30-Jul-14 0:20 
GeneralRe: Mouse event Handling [SOLVED] Pin
V.30-Jul-14 0:24
professionalV.30-Jul-14 0:24 
QuestionGoogle Drive files and folders listing in asp.net web application using c# and Google Apis Pin
NIYAS PK29-Jul-14 20:04
NIYAS PK29-Jul-14 20:04 
AnswerRe: Google Drive files and folders listing in asp.net web application using c# and Google Apis Pin
Pete O'Hanlon29-Jul-14 20:49
mvePete O'Hanlon29-Jul-14 20:49 
QuestionWhat options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
agent15429-Jul-14 15:05
agent15429-Jul-14 15:05 
I'm aware of at least two possibilities for reading directly from xls files:

- Microsoft.Office.Interop.Excel
- Microsoft.ACE.OLEDB.12.0 OleDB provider

From what little information I've been able to find on the subject, it seems that the Microsoft.Office.Interop.Excel method requires that Excel be installed on the system where this will be run. Is this true?

Basically, I want a reliable (read: can be run on any system Windows 7 or higher with or without office installed) to read data from an XLS or XLSX spreadsheet. I don't need to do any writing to the format, I just need to read from it and dump the data into a SQLite or SQL Server Compact database table.

Are there any methods other than those two I mentioned, and which would be the highest recommended method of doing what I need?

Thanks.
AnswerRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
PIEBALDconsult29-Jul-14 15:14
mvePIEBALDconsult29-Jul-14 15:14 
AnswerRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
SledgeHammer0129-Jul-14 18:09
SledgeHammer0129-Jul-14 18:09 
GeneralRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
Mycroft Holmes29-Jul-14 19:18
professionalMycroft Holmes29-Jul-14 19:18 
AnswerRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
Bernhard Hiller29-Jul-14 20:34
Bernhard Hiller29-Jul-14 20:34 
AnswerRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
Richard Deeming30-Jul-14 1:33
mveRichard Deeming30-Jul-14 1:33 
AnswerRe: What options do I have for reading data from an excel spreadsheet, and what are the limitations of each? Pin
jschell31-Jul-14 9:29
jschell31-Jul-14 9:29 
Questionstack / heap assignment under the hood Pin
taking_liberties29-Jul-14 4:06
taking_liberties29-Jul-14 4:06 
AnswerRe: stack / heap assignment under the hood Pin
Simon_Whale29-Jul-14 4:29
Simon_Whale29-Jul-14 4:29 
GeneralRe: stack / heap assignment under the hood Pin
harold aptroot29-Jul-14 4:52
harold aptroot29-Jul-14 4:52 
GeneralRe: stack / heap assignment under the hood Pin
taking_liberties29-Jul-14 6:42
taking_liberties29-Jul-14 6:42 
AnswerRe: stack / heap assignment under the hood Pin
OriginalGriff29-Jul-14 5:07
mveOriginalGriff29-Jul-14 5:07 
GeneralRe: stack / heap assignment under the hood Pin
Rob Philpott29-Jul-14 6:19
Rob Philpott29-Jul-14 6:19 
GeneralRe: stack / heap assignment under the hood Pin
OriginalGriff29-Jul-14 6:25
mveOriginalGriff29-Jul-14 6:25 
GeneralNot enough storage is available to complete this operation Pin
Tal Humy29-Jul-14 3:20
Tal Humy29-Jul-14 3:20 
QuestionRe: Not enough storage is available to complete this operation Pin
Eddy Vluggen29-Jul-14 6:24
professionalEddy Vluggen29-Jul-14 6:24 
GeneralRe: Not enough storage is available to complete this operation Pin
Bernhard Hiller29-Jul-14 20:43
Bernhard Hiller29-Jul-14 20:43 
QuestionOData 4 $InLineCount Pin
JoelPark28-Jul-14 10:58
JoelPark28-Jul-14 10:58 

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.