It is so that I am looking for a solution that can retrieve all data in coli to be used ,. and I am also looking for eg row row to be put the same in one with the number of hours allocated in each area.
Hope there is someone who can help me ,. i have looked at this in relation to coli with that data from the single area.
Console.WriteLine("Start?");
Console.ReadKey(true);
var filePath = FileServices.FilePath();
var fileName = FileServices.GetFileName();
// Open source Excel file
Aspose.Cells.Workbook sourceWorkbook = new Aspose.Cells.Workbook(filePath + fileName);
// Open destination Excel file
Aspose.Cells.Workbook destinationWorkbook = new Aspose.Cells.Workbook(filePath + fileName);
// Copy the first sheet of the source workbook into destination workbook
destinationWorkbook.Worksheets["TimeLog Converted"].Copy(sourceWorkbook.Worksheets["TimeLog Converted"]);
foreach (var item in MemberServices.GetMembers())
{
Console.WriteLine($"Faktura: {item}");
Console.WriteLine(destinationWorkbook.DataMashup);
// Save the Excel file
var newFileName = FileServices.NewFileName(item);
destinationWorkbook.Save(filePath + newFileName);
Console.WriteLine("----------------------");
}
Console.WriteLine("Done");