I have a query related to MAPS. Query is,I want to export Maps with data in excel format.
Let me give an example,let us say we have different organizations name of different countries,and each organization has its own recods about its production.
I want to show those countries(in different colored area ,decsending with production data) with their data in world Maps in Excel.I am looking a tool for Net3.5.
Please go through the attached file.
Please confirm me which tool I should use to meet my requirements.
Hi Rajesh Kumar,
Thanks for your inquiry.
Well, your report is pretty simple, I think Aspose.Cells for .NET suits your need. Aspose.Cells for .NET has a rich set of features, it supports all .NET frameworks i.e.., 1.x, 2.x, 3.x etc.Using the component's APIs you may input all types of data, insert pictures, organize your data(data sorting), set the columns width / row heights for the cells. Moreover, you may format data into the cells, add borders around cells and make the grid lines invisible and more.
For your further reference, I paste some of the documentation links here:
Also, you may try to check our featured demos:
Hi Rajesh Kumar,
I think you may easily insert map image, make portions of cells, set cells formattings (set colors, set font attributes, numbers formattings, add borders etc.). Kindly check the links which I have provided you in my previous post, thank you.
The following sample code demonstrate one way (certainly there are other options to do the job) to accomplish your task (filling colors into the cells for a state portion). I think you may consult the sample code and create your own easily. The output file is also attached.
Note: This sample code is just an example describing how you can go on with your task.
Workbook workbook = new Workbook();
//MS Excel color palette has only 56 colors(0-55 indexed)
//If a color is not present, you need to add to the palette first
//Adding GreenYellow color to the palette.
//Get the first (default) in the workbook.
Worksheet currentWorksheet = workbook.Worksheets;
currentWorksheet.IsGridlinesVisible = false;
//Create a new style object.
Style newStyle = workbook.Styles[workbook.Styles.Add()];
//Set the filling color
newStyle.ForegroundColor = Color.LightGreen;
//Set the pattern type.
newStyle.Pattern = BackgroundType.Solid;
//Create the style flag object.
StyleFlag flag = new StyleFlag();
//Set cellshading on.
flag.CellShading = true;
//Create a range of cells (B7:E39)
Range myrange = currentWorksheet.Cells.CreateRange("B7", "G35");
//Set the outline borders for the range
//Apply the style for the range.
myrange[1, 1].PutValue("United Kingdom");
myrange[1, 1].Style.Font.IsBold = true;
//Save the workbook.
And, kindly check the following doc topics too:
And here is technical article (on formatting worksheets) if you can check it: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/format-worksheet-cells-in-a-workbook.html