Click here to Skip to main content
15,913,090 members
Home / Discussions / C#
   

C#

 
GeneralRe: Get data from the clipboard Pin
Heath Stewart24-Nov-04 6:24
protectorHeath Stewart24-Nov-04 6:24 
GeneralICO to JPEG Pin
CyberTech24-Nov-04 2:19
CyberTech24-Nov-04 2:19 
GeneralRe: ICO to JPEG Pin
Heath Stewart24-Nov-04 10:17
protectorHeath Stewart24-Nov-04 10:17 
GeneralQuery on Scrolling Pin
pradeep_pc24-Nov-04 0:46
pradeep_pc24-Nov-04 0:46 
GeneralRe: Query on Scrolling Pin
Daniel Turini24-Nov-04 1:09
Daniel Turini24-Nov-04 1:09 
GeneralProgramatically place characters in an input stream Pin
SebbaP24-Nov-04 0:42
SebbaP24-Nov-04 0:42 
GeneralRe: Programatically place characters in an input stream Pin
Daniel Turini24-Nov-04 1:02
Daniel Turini24-Nov-04 1:02 
GeneralComparing Strings with Wildcards Pin
pjholliday23-Nov-04 23:48
pjholliday23-Nov-04 23:48 
GeneralRe: Comparing Strings with Wildcards Pin
Stefan Troschuetz24-Nov-04 0:23
Stefan Troschuetz24-Nov-04 0:23 
QuestionSystem-wide CBT in .NET? Pin
Hadi Fakhreddine23-Nov-04 22:58
Hadi Fakhreddine23-Nov-04 22:58 
AnswerRe: System-wide CBT in .NET? Pin
Heath Stewart24-Nov-04 6:19
protectorHeath Stewart24-Nov-04 6:19 
GeneralRe: System-wide CBT in .NET? Pin
Hadi Fakhreddine24-Nov-04 6:36
Hadi Fakhreddine24-Nov-04 6:36 
GeneralRe: System-wide CBT in .NET? Pin
Heath Stewart24-Nov-04 8:23
protectorHeath Stewart24-Nov-04 8:23 
GeneralRe: System-wide CBT in .NET? Pin
Hadi Fakhreddine24-Nov-04 20:50
Hadi Fakhreddine24-Nov-04 20:50 
QuestionHow to Update Primary keys? Pin
Old Gun23-Nov-04 21:22
Old Gun23-Nov-04 21:22 
AnswerRe: How to Update Primary keys? Pin
sreejith ss nair24-Nov-04 3:59
sreejith ss nair24-Nov-04 3:59 
AnswerRe: How to Update Primary keys? Pin
Heath Stewart24-Nov-04 6:14
protectorHeath Stewart24-Nov-04 6:14 
GeneralHave no node selected or Hide Tree view first Node Pin
tejas_kan23-Nov-04 20:45
tejas_kan23-Nov-04 20:45 
GeneralRe: Have no node selected or Hide Tree view first Node Pin
Daniel Turini24-Nov-04 1:04
Daniel Turini24-Nov-04 1:04 
GeneralRe: Have no node selected or Hide Tree view first Node Pin
Anonymous24-Nov-04 1:11
Anonymous24-Nov-04 1:11 
QuestionDoes Font.Height or Font.GetHeight() return correct font height? Pin
sachinkalse23-Nov-04 19:08
sachinkalse23-Nov-04 19:08 
AnswerRe: Does Font.Height or Font.GetHeight() return correct font height? Pin
Heath Stewart24-Nov-04 6:11
protectorHeath Stewart24-Nov-04 6:11 
GeneralQuick question on hotkeys Pin
Flack23-Nov-04 16:27
Flack23-Nov-04 16:27 
GeneralRe: Quick question on hotkeys Pin
benjymous23-Nov-04 22:32
benjymous23-Nov-04 22:32 
GeneralNeed help accessing an Excel range of cells Pin
Flack23-Nov-04 16:25
Flack23-Nov-04 16:25 
Im new to using Excel with C# and I ccant seem to get this seemingly simple task done.

What I want to do is get a range of cells from an Excel sheet and put the resulting cell values in a string array. (I know that the values are all strings).

The code I have that gets the job done is this:
<br />
string workbookPath = fileName_;<br />
Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath,0,true,5,"","",true,Excel.XlPlatform.xlWindows,"",false,false,0,true,false,false);<br />
Excel.Sheets excelSheets = excelWorkbook.Worksheets;<br />
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(1);<br />
Excel.Range excelCells = (Excel.Range)excelWorksheet.get_Range("A1","H1");<br />
System.Object[,] result = (System.Object[,])excelCells.EntireRow.Value2;<br />


Now, this code gives me a two-dimensional array with all of the values included, along with every other null item in that row (giving me an array with a second dimension length of 256).

I tried doing:
<br />
System.String[] result = (System.String[])excelCells.Value2;<br />

because I can see that excelCells.Value2 is an array. Unfortunately, this line gives me an invalid cast exception.

Is this way the only way I can get an Excel row into an array (without going through each cell manually, getting its value, and adding it to an array)?

How about if I wanted to multiple rows, like ("A1","H7")?

Thanks,
-Flack

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.