Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
150944 | Jan 25,2020 09:23 AM UTC | Feb 3,2020 11:44 AM UTC | WPF | 5 |
![]() |
Tags: XlsIO |
worksheet.InsertRow(23, 10, ExcelInsertOptions.FormatAsBefore); |
string currencySymbol = System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencySymbol;
worksheet.Range["A1"].NumberFormat = currencySymbol + "#,##0.00"; |
Hi Andreas,
Greetings from Syncfusion.
New rows can be inserted into a table using the InsertRow method option available under IWorksheet interface.
Code Snippet:
worksheet.InsertRow(23, 10, ExcelInsertOptions.FormatAsBefore);
Please look into the following link to know more about this.
You can retrieve the currency symbol from OS and set the number format, using the following code snippet.
Code Snippet:
string currencySymbol = System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencySymbol;worksheet.Range["A1"].NumberFormat = currencySymbol + "#,##0.00";
Kindly try this and let us know if the provided suggestion helps you.
Regards,Keerthi.
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.