Trying to save excel file in C#

Question

Hello i have this code in c# that inserts values in excel and then saves the file but i get an error saying Error saving file C:\Users\user\Desktop\Phone.xlsx

This is the code:

  Regex re = new Regex(@"\s*\+\d+ \d{3}-\d{3}-\d{4}"); //\w{8}, \w{2}, \w[a-zA]{5}
                    var matches = re.Matches(tag.InnerText);
                    foreach (Match m in matches)
                    {
                        lines.Add(m.Value);
                            count = lines.Count;
                            try
                            {
                                sheet.Cells.LoadFromCollection(lines, true);
                            }catch(Exception ex)
                            {
                                Console.WriteLine(ex.Message);
                            }
                    }
                    if (matches.Count == 0)
                    {
                        lines.Add("Sorry no phone number found!");
                    }
               }
 FileInfo excelFile = new FileInfo(@"C:\Users\user\Desktop\Phone.xlsx");
                try
                {
                    xlWorkbook.SaveAs(excelFile); //error happens here
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }

@DS_London so i do it like `xlWorkbook.SaveAs("C:\Users\user\Desktop\Phone.xlsx");` ? — youngcoder, Aug 20 '22 at 11:51
@PeterSmith yes you are right i will add also the if exist part too — youngcoder, Aug 20 '22 at 11:52
@youngcoder I don’t do much C# … not sure if you need to ‘escape’ the backslash as `xlWorkbook.SaveAs("C:\\Users\\user\\Desktop\\Phone.xlsx");` for string literals. — DS_London, Aug 20 '22 at 12:08

MerlinRolf Adam · Answer 1 · 2022-08-20T11:55:18.843

0

check detail Exception about error you get (inner Exception ) and tell more about it . also i think change save directory to another location , for example D:\ , don't use C:\

edited Aug 20 '22 at 11:55

answered Aug 20 '22 at 11:53

MerlinRolf Adam

1
1

Trying to save excel file in C#

1 Answers1