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.
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:
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
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");