What's SAS? Can you give us more information about it?
2. Copy the data from the CSV file directly into an Excel worksheet that has our pre-defined template (mainly pivot tables feeding off raw data worksheets and refreshing the pivot table automatically on open, thus the raw data worksheet is where we need the CSV data to be placed) - This is where we want to use Aspose.Cells so that we can run multiple excel outputs simultaneously - currently we use SAS and we can only output to one Excel file at a time which is very inefficient.
I think you can create a multi-thread application. In the main thread, you can create a Workbook object and it contains the pre-defined template.
In each worker thread, you can create 2 Workbook objects.
Workbook wb1 = new Workbook();
wb1.Open(csvFile); // load data from CSV file
Workbook wb2 = new Workbook();
wb2.Copy(sourceWorkbook); //copy data from the main thread's Workbook object which contains the pre-define template
//Copy data from wb1 to wb2
for(int i = 0; i < wb1.Worksheets.Cells.Count; i ++)
Cell source = wb1.Worksheets.Cells[i];
Cell dest = wb2.Worksheets.Cells[cell.Row, cell.Column];
3. The CSV data to the Excel file needs to be done automatically using SAS. Within SAS we can execute VB scripts, DOS scripts for example but not sure if Aspose.Cells can tie into all this somehow.
You can use VB scripts to invoke Aspose.Cells. Please check http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/accessing-component-from-com-clients.html . Though you can access Aspose.Cells from VB scripts, we suggest you to develop a .Net program to wrap all complex calls. You VB scripts is better to use only one method call. Otherwise, programming will be tedious and hard to debug because Aspose.Cells is a pure .Net component.
4.We dont have VS.Net installed and again its not on our authorised software list and thus it is very unlikely to be authorised.
Aspose.Cells is a .Net component. So .Net Framework is a must. You can totally call it in VB scripts as I suggested above. But it will be a hard work. Maybe you can try to use some other .Net IDE, such as http://www.icsharpcode.net/OpenSource/SD/ . And you can search on Internet for other tools.