Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; ... Excel.Application xlApp = new Excel.Application(); xlApp.Visible = false; //http://support.microsoft.com/default.aspx?scid=kb;en-us;320369 workaround System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US"); System.Threading.Thread.CurrentThread.CurrentCulture = ci; ... Excel._Workbook wb = (Excel._Workbook)(xlApp.Workbooks.Add(Missing.Value)); Excel._Worksheet ws = (Excel._Worksheet)wb.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value); ... Excel.Range formularRange = ws.get_Range("D2","D2"); //working code: formularRange.Formula = "=C2/B2"; //code throwing exception formularRange.Formula = "=IF(B2=0;0;C2/B2)";
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.