i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a cell
that is suppose to calculate the total of a column, it won't add the
total because my numbers are being inserted as text, any easy fixes??

Hi
could you post the relevant part of your code that inserts the values
in Excel

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:
i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a
cell that is suppose to calculate the total of a column, it won't add
the total because my numbers are being inserted as text, any easy
fixes??

well it's actually kind of tricky, i grab a bunch of pay roll
information and create an area for each cell in a row, then i add that
row to an array of rows for the whole page and then i add it to excel,
but theres a bunch of extra formatting i do

for(int i = 0; i < pagearray.Length; i++)
{
//add 2 to the array to add values in after the headers
int irow = i + 2;
Excel.Range range = (Excel.Range)sheet.Cells.get_Range("A" +
irow.ToString().Trim(),"P" + irow.ToString().Trim());
range.Value2 = pagearray[i];

//this is the relevant part of the code

Frank Kabel wrote:

Hi
could you post the relevant part of your code that inserts the values
in Excel

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:

i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a
cell that is suppose to calculate the total of a column, it won't add
the total because my numbers are being inserted as text, any easy
fixes??

Hi
if each element in your pagearray is a numeric value why not convert it
to a number before inserting it into Excel (don't know the C# syntax
for this).

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:
well it's actually kind of tricky, i grab a bunch of pay roll
information and create an area for each cell in a row, then i add
that
row to an array of rows for the whole page and then i add it to
excel,[i]
but theres a bunch of extra formatting i do

for(int i = 0; i < pagearray.Length; i++)
{
//add 2 to the array to add values in after the headers
int irow = i + 2;
Excel.Range range = (Excel.Range)sheet.Cells.get_Range("A" +
irow.ToString().Trim(),"P" + irow.ToString().Trim());
range.Value2 = pagearray;

//this is the relevant part of the code

Frank Kabel wrote:

Hi
could you post the relevant part of your code that inserts the
values
in Excel

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:

i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a
cell that is suppose to calculate the total of a column, it won't
add the total because my numbers are being inserted as text, any
easy fixes??

Good point, as simple as that solution it escaped me, thanks a lot

Frank Kabel wrote:
[i]
Hi
if each element in your pagearray is a numeric value why not convert it
to a number before inserting it into Excel (don't know the C# syntax
for this).

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:

well it's actually kind of tricky, i grab a bunch of pay roll
information and create an area for each cell in a row, then i add

that

row to an array of rows for the whole page and then i add it to

excel,

but theres a bunch of extra formatting i do

for(int i = 0; i < pagearray.Length; i++)
{
//add 2 to the array to add values in after the headers
int irow = i + 2;
Excel.Range range = (Excel.Range)sheet.Cells.get_Range("A" +
irow.ToString().Trim(),"P" + irow.ToString().Trim());
range.Value2 = pagearray;

//this is the relevant part of the code

Frank Kabel wrote:


Hi
could you post the relevant part of your code that inserts the

values

in Excel

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:


i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a
cell that is suppose to calculate the total of a column, it won't
add the total because my numbers are being inserted as text, any
easy fixes??