We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

MAPS report

Hi Aspose,

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.

Thanks

Rajesh Kumar,

rajeshk@safaltek.in

India

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:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/installation.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/your-first-application-using-aspose-cells-hello-world.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/accessing-cells-of-a-worksheet.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adding-data-to-cells.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/data-sorting.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adding-pictures.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adjusting-row-height-column-width.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/approaches-to-format-data-in-cells.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/setting-display-formats-of-numbers-dates.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adding-borders-to-cells.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/display-or-hide-gridlines.html

Also, you may try to check our featured demos: http://www.aspose.com/demos/aspose.cells/default.aspx

Thank you.

Hi ,

I want to color states and countries dynamically.I can not take static image for this.One thing i can do is ,I ll take static country map but filling color into its states will be dynamically.

Let me know the tool and sample example so that i can finalize the tool ASAP

Thanks,

Rajesh Kumar

India

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.

Sample code:

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.
workbook.ChangePalette(Color.LightGreen, 55);
//Get the first (default) in the workbook.
Worksheet currentWorksheet = workbook.Worksheets[0];
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
myrange.SetOutlineBorders(CellBorderType.Double, Color.Red);
//Apply the style for the range.
myrange.ApplyStyle(newStyle, flag);
myrange[1, 1].PutValue("United Kingdom");
myrange[1, 1].Style.Font.IsBold = true;

//Save the workbook.
workbook.Save("f:\\test\\test_Colorrange1.xls");

And, kindly check the following doc topics too:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/colors-and-palette.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/named-ranges.html

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

Thank you.