XAMARIN ANDROID C# EXPORT SMS TO CSV

For this purpose you have to go for some third party SDK which provides you this flexibility. I have worked with ByteScout Spreadsheet SDK which serve the purpose and gives you flexibility to read/write your excel/cvs file. Below is the sample code you can modify it according to your need.

// Create new Spreadsheet
Spreadsheet document = new Spreadsheet();
// Add new worksheet
Worksheet worksheet = document.Workbook.Worksheets.Add(“SimpleReport”);
// Set Values
worksheet.Cell(0, 0).Value = “Name”;
worksheet.Cell(0, 1).Value = “Full Name”;
// Set font bold for headers
worksheet.Cell(0, 0).Font = new Font(“Arial”, 12, FontStyle.Bold);
worksheet.Cell(0, 1).Font = new Font(“Arial”, 12, FontStyle.Bold);
worksheet.Cell(1, 0).Value = “Homer”;
worksheet.Cell(1, 1).Value = “Homer Jay Simpson”;
worksheet.Cell(2, 0).Value = “Marjorie”;
worksheet.Cell(2, 1).Value = “Marjorie Marge Simpson (Bouvier)”;
worksheet.Cell(3, 0).Value = “Bartholomew”;
worksheet.Cell(3, 1).Value = “Bartholomew Jojo Bart Simpson”;
worksheet.Cell(4, 0).Value = “Lisa”;
worksheet.Cell(4, 1).Value = “Lisa Marie Simpson”;
worksheet.Cell(5, 0).Value = “Margaret”;
worksheet.Cell(5, 1).Value = “Margaret Maggie “;
// Save document
document.SaveAs(“SimpleReport.xls”);

Please visit the official link for more details.

https://bytescout.com/products/developer/spreadsheetsdk/bytescoutspreadsheetsdk.html

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Raheel Ahmad7y ago
For this purpose you have to go for some third party SDK which provides you this flexibility. I have worked with ByteScout Spreadsheet SDK which serve the purpose and gives you flexibility to read/write your excel/cvs file. Below is the sample code you can modify it according to your need.
// Create new Spreadsheet
Spreadsheet document = new Spreadsheet();
// Add new worksheet
Worksheet worksheet = document.Workbook.Worksheets.Add(“SimpleReport”);
// Set Values
worksheet.Cell(0, 0).Value = “Name”;
worksheet.Cell(0, 1).Value = “Full Name”;
// Set font bold for headers
worksheet.Cell(0, 0).Font = new Font(“Arial”, 12, FontStyle.Bold);
worksheet.Cell(0, 1).Font = new Font(“Arial”, 12, FontStyle.Bold);
worksheet.Cell(1, 0).Value = “Homer”;
worksheet.Cell(1, 1).Value = “Homer Jay Simpson”;
worksheet.Cell(2, 0).Value = “Marjorie”;
worksheet.Cell(2, 1).Value = “Marjorie Marge Simpson (Bouvier)”;
worksheet.Cell(3, 0).Value = “Bartholomew”;
worksheet.Cell(3, 1).Value = “Bartholomew Jojo Bart Simpson”;
worksheet.Cell(4, 0).Value = “Lisa”;
worksheet.Cell(4, 1).Value = “Lisa Marie Simpson”;
worksheet.Cell(5, 0).Value = “Margaret”;
worksheet.Cell(5, 1).Value = “Margaret Maggie “;
// Save document
document.SaveAs(“SimpleReport.xls”);
Please visit the official link for more details.
https://bytescout.com/products/developer/spreadsheetsdk/bytescoutspreadsheetsdk.html
0