|
I have added a excel spreadsheet with 2 columns. Could anyone be kind enough to point me in the direct of how to loop through each of the cells in the first column, or even provide the code to do it.
Thanks in advance.
|
|
|
|
|
|
I want to point the best alternative in my experience is to use NPOI library you dont need excel installed.
There are several examples in the codeplex site.
AUS Enrique Ferreyra
(Pachu)
|
|
|
|
|
You should have sent this reply to the original questioner, rather than to me.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Thanks for that. Do you have any links relating to the syntax for referencing the resource file itself?
|
|
|
|
|
What do you mean by "resource file"? Your question asked about accessing Excel columns.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
|
Sorry, I don't know how you would access the content from there, you would probably need to write it to disk first. However, since resources are constant data I see no benefit in putting an Excel formatted file into your resources, it would be much easier to convert it to XML or similar.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
It's a data of data that I use to do lookups on. I was doing this project in Access, but am now using Visual Studio. I was only putting the data in an Excel spreadsheet because I thought it would be easier to access.
For this type of information (2 columns (lookup A, bring back B), can you suggest an alternative method of storing the data within the solution for retrieval?
You mentioned XML - would that be suitable?
|
|
|
|
|
The first question you need to answer is: what is this data for, and why is it necessary to hold it in a resource, rather than as a constant table in the program? If you are certain that this is the best way to store it then you should choose a storage medium that is easy to access from within the program. You could use XML, a text or binary stream etc. It all depends on how much data and what you need to use it for.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
As for the data I have, it's around 2000 x 2 "cells".
As I'm unfamiliar with how to approach this, a resource file was just one option. Currently I'm having the user select my original database, and then importing the table to a datatable via OLEDB.
Whilst this works, ideally I'd like the data embedded so I don't have to distribute a database with the actual application.
|
|
|
|
|
If it is constant data then it should be embedded into the program rather than held as an external database, that just adds unnecessary work.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Ok, thank you. 
If anyone can propose the best way of doing this, I'd be most grateful, as I know nothing on the subject. Many thanks.
|
|
|
|
|
Member 9704153 wrote: I know nothing on the subject.
What subject are you referring to? As I understand it you have some constant data that your program needs to use as it runs, so all you need to do is add some sort of constant array, class, structure or collection that contains all the data.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Do you mean hard code the table into the C# code?
|
|
|
|
|
Well, as I said before that is one way of doing it. But, you really need to go back to my earlier question where I suggested you look more closely at what this data is for and why you need it in your program. You have not really given a very clear description of what problem you are trying to solve, apart from saying you have 2000 x 2 values of some sort, which you are trying to access in your code. What are these values and what are you trying to do with them?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
The values are strings.
I'm importing a spreadsheet and converting it. For each row, I need to add a number relating to a value in one of the row's cells. This number is what I am looking up.
|
|
|
|
|
So we are back to manipulating a spreadsheet ... then use the Interop reference I gave you in the first response to access and update it.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Sadly it's not just as simple as manipulating a spreadsheet. The data is manipulated, but rows are chopped up and re-arranged, which is what I'm doing with C#/datatables. Looking up these values is just a small part of the whole solution.
|
|
|
|
|
Richard MacCutchan wrote: I don't know how you would access the content from there,
Assembly.GetManifestResourceStream?
Bob Dole The internet is a great way to get on the net.
 2.0.82.7292 SP6a
|
|
|
|
|
Probably yes, but the issue is a bit more than that.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi,
Using ASP.Net - I want to copy the data from a table into a predefined csv template file.
The csv file has two header rows. One header row defines how many rows are in the file.
The second header row is the actual data from one table in sql server. A format is specified below.
Can I use BCP command in sql server, have that specified in stored procedure and have the asp.net application call this stored proc.
Maybe have the data start inserting from row 4.
==============
date=01132013,rowcount=1
merchantrefcode,ordernumber,currency,total
auth01111,50122222,USD,123.90
===============
|
|
|
|
|
Why wouldn't your app just create the whole thing?
Plus, I recommend using a better date format if possible (YYYYMMDD).
|
|
|
|
|
Hello CP, I'm making a login screen that automaticaly full-screens on startup, and what I would like to know is:
- how do I get the resolution the OS is using?
- how can I center my objects in the form depending on that resolution?
For example, my computer is using 1920x1080, the form obviously is only about 200x200 big, and when I full-screen it on startup the objects that I placed there are obviously going to be on the wrong places. What I wanted is to center the objects just like it is on the Win7 login screen.
Thanks in advance.
|
|
|
|
|
See the documetation on the Screen class[^].
But, you can set the forms StartPosition property to FormStartPosition.CenterScreen before you ShowDialog the form and it'll be done for you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
