473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Working Excel file with C#

Hi, i'm using C# Visual Studio 2008 for made a apps able to take some information from the app and sending them to
a excel template, i'm using Microsoft.Office.Interop.Excel namespace and i don't have problem getting the file
and putting the info to the rows, but i'm not getting the correct result because all the values are seen like text.

I have a string[,] SaRet array that capture all the info to write on excel, by example
SaRet = {Meng1, Ful1, 0, 1, =(2*B2)}
when i use the method: range.set_Value(System.Reflection.Missing.Value, saRet) everything i's a text value (Ok, the

source its a string, so it's logical ) and i was wondering if exist a option for let Excel know how work each cell.

Another question: It's possible use automation for make a dropdown list for the formulas cell?
because the real formula it's very long and it's a little rodundant write the formula on C# for each row and the
pass it to excel (The excel file can be use without the App so, the formula must be there )

P.d. I'm still practicing my english
Apr 14 '09 #1
0 1733

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Otie | last post by:
I found the following under the GetObject help notes and in the example for GetObject: "This example uses the GetObject function to get a reference to a specific Microsoft Excel worksheet...
1
by: Rocky A | last post by:
I need to open an excel workbook and import info to my access program. That isn't the problem, I've got the code down for doing what I want to do. I'm declaring the variable and setting it like...
5
by: Oscar Thornell | last post by:
Hi! Does anybody know any articles / code exampels / bloggs etc or does in any other way have tips on working with Excel spreedsheets trough .NET? I can not use the Excel.dll it must all take...
2
by: Brent | last post by:
Ok this is driving me nuts.. I add a com reference to the excel 11.0 library and throw this in Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng...
3
by: Michael Kellogg | last post by:
My application works with Excel to put together spreadsheets for reporting purposes. It runs just fine on my box, but when I put it on another one, it bombs. Here is the relevant code: ...
3
by: Benny Raymond | last post by:
I get the following error message when trying to use the Excel Interop on my wife's machine however I don't get it on my own - we have the same version of Office installed - what could be the...
6
by: AleydisGP | last post by:
I have a .plt file (which is a tab delimited ASCII file) and I want to format it to get a .dbf with data in rows and columns, detele some rows/columns and substitute decimal '.' with ','. All this...
10
by: Tim C | last post by:
I have the following code associated with a button in an Access form: stDocName = "Table1" DoCmd.OutputTo acReport, stDocName, acFormatXLS, "TestFileName.xls" When I open "TestFileName.xls"...
3
by: =?Utf-8?B?c3Jpbml2YXM=?= | last post by:
Hi All, My ASP.net application has to fetch data from Excel sheet. I'm using HTML File Control to select an excel file. I'm using Microsoft.Jet.OLEDB.4.0 provider to fetch the data from excel....
4
by: stephen | last post by:
Hi all, I am working with Excel. I read an excel document using ExcelReader and lets say it has 10 columns. I have to read each record and based on a specified column peform some activites and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.