C# SaveAs Excel error

Question

I am trying to save a pipe delimited text file into an excel worksheet format. I am having some errors in the code, below is my code:

TextFile.SaveAs(Filename:=strExcelOutputFilename,
                FileFormat:=Excel.XlFileFormat.xlWorkbookNormal);

Where TextFile is an Excel.Workbook object (Editor's note).

I am having some syntax errors at TextFile.SaveAs portion. Please help me identify any other errors if I have made them, thanks alot!

EDIT: After correction of := to : (Editor's note)

Below is a screenshot of the lines i am having error at, as well as the error list:

enter image description here

MPelletier · Accepted Answer · 2011-11-04 03:27:28Z

1

:= is not a valid C# operator, you just need :

Example:

TextFile.SaveAs(Filename: strExcelOutputFilename, FileFormat: Excel.XlFileFormat.xlWorkbookNormal);

Source: http://msdn.microsoft.com/en-US/library/ms178843.aspx

edited Nov 4, 2011 at 3:27

answered Nov 4, 2011 at 3:22

MPelletier

16.8k18 gold badges91 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

gymcode Over a year ago

after i removed them, ":strExcelOutputFilename, FileFormat" are underlined in red and it seems to have a syntax error in them :/

MPelletier Over a year ago

There's more to debugging than just looking if there's a red line. Open your Error List (View > Error List), try to compile, and read what the error says.

MPelletier Over a year ago

Ah, good! But it doesn't speak much, does it? I don't know what it is at this point, I can't see it. Try removing your FileFormat for a minute, see what it gives you.

gymcode Over a year ago

It still says ; expected, with strExcelOutputFilename underlined after removing FileFormat

Collectives™ on Stack Overflow

C# SaveAs Excel error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related