Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

learn more… | top users | synonyms (2)

0
votes
0answers
4 views

insufficient memory available --error code was 2.offending plugin is 'xlsx'

I am using an excel file and esri sde database to detect the changes using change detector tool.the output is an excel file with the changes.The tool runs fine on the small excel file, but as soon ...
1
vote
2answers
19 views

Joining Excel tables to data attribute in ArcMap?

I am trying to join an Excel table to my parcel attribute table in ArcMap. I have run a validation and all checks out except it says there are no matches. What would cause this?
0
votes
0answers
28 views

Updating table from Excel spreadsheet using ArcPy? [on hold]

This is my code import arcpy arcpy.env.workspace = r"D:\Users\ShawnO\Desktop\PythonExercizes\Parcel_Ownership_update_model\Parcels.gdb" # Local variables: Parcel_Owners = "D:\\Users\\ShawnO\\Desktop\...
2
votes
3answers
93 views

Adding excel table to QGIS print composer?

Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then ...
3
votes
1answer
49 views

Attaching Excel sheet with different language font(hindi) to shapefile

When I try to join a excel sheet with Hindi font to a shp file, I get '?????' as a result in those cells which has Hindi font. (Before/Aft images attached) I tried changing the locale language to ...
1
vote
0answers
32 views

automatically update Arcmap attribute when updatin Excel table

I have a map in arcmap where i want to display information that contains values that will probably change every year. I would rather not having to remove joins and then join my new excel sheet every ...
-1
votes
1answer
44 views

Export field list to excel or csv

I've got the below script and found very useful. But I need the list of fields to be exported to excel or csv. import arcpy #Set workspace environment to geodatabase arcpy.env.workspace = "e:/temp/...
0
votes
0answers
25 views

Enter Latitude and Longitude in CSV file using Javascript [closed]

I used ESRI Geolocation code to get my current location then put the Longitude and Latitude into an array. On my computer I have a CSV file called "XYcoors.csv" and would like to put these ...
1
vote
0answers
23 views

Arcpy code repetition provides slight differences in the outputs [closed]

I made a python script that uses arcpy to buffer some network areas, intersect them with another shapefile, and from this output make some calculations that are saved to an Excel spreadsheet. I run ...
1
vote
0answers
14 views

Google Earth 1.0 Type Library Missing

I've been running Excel to Google Earth Dashboards for some time through VBA on Windows 7 and Excel 2010. However, I have just tried to copy one of my workbooks to a Windows 8.1 machine on Excel 2016 ...
0
votes
1answer
79 views

Coordinates from Excel list

I'd like to import Coordinates from an Excel list, for this reason I saved the excel sheet as an .csv ant tried to import it via "Layer --> Add delimited text Layer". The points are imported, but with ...
1
vote
1answer
21 views

exporting attribute tables of multiple rasters to excel

I had a raster and I clipped it using a shapefile of polygons. Now I have about 5500 individual raster images. I have to export the attribute table of each raster to excel so that I can then append ...
0
votes
1answer
38 views

Relating shapefile to excel table in ArcMap?

I have successfully joined a point shapefile to .CSV file in ArcMap 10.0, and the type of the fields which are related in the two files are the same(text, length:255). But when I remove join and ...
0
votes
1answer
27 views

Assigning/joining tabulated data to features in MapInfo?

I am not a MapInfo user, but I have been asked whether that software can assign/join tabulated data to GIS features like buildings, roads and watercourses?
2
votes
2answers
81 views

Why can I only view 2000 records of an Excel table (ArcGIS)?

I have added a 97-2003 Excel document to ArcMap to compare data. The file has approximately 3200 records. When I initially open the table in Arc it shows all 3200 records, but as soon as I attempt to ...
3
votes
1answer
63 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom geometry(...
1
vote
0answers
19 views

Looking for Polygon data on NUTS2 (2013 system) in CSV or Excel?

Looking for Polygon data on NUTS2 (2013 system). Can somebody supply this in CSV or Excel? I have been searching on NUTS2 Polygon data, but unlucky so far. I have found the data but this is in ...
1
vote
1answer
27 views

CartoDB: Geometry code too long, Excel can't handle it

I am working on a map of regions where I want to be able to visualize some simple numbers on a periodical basis. I have a dataset with the polygons . However those are so detailed (the geometry is ...
0
votes
1answer
35 views

How to edit a table in order to count the number of points in the same location?

Using QGIS, I have a point shapefile that has multiple points with same coordinates across different locations. I need a count of those points. For example there are 15 features that have the exact ...
1
vote
2answers
65 views

When the table is too big for it to get exported to excel in arcgis ModelBuilder

My model output got way too many rows to be exported to excel in arcgis ModelBuilder. It would work if I could use the new xlsx file format but it seems the toolbox can only do xls. After a little ...
1
vote
0answers
23 views

Failed executing “Table to Excel” in ArcGIS

Can't export polygon shapefile into Excel sheet. When executing Table to Excel in ArcGIS shows this error: ERROR 000576: Script associated with this tool does not exist. Failed to execute (...
0
votes
1answer
21 views

Arcpy TabletoExcel input error

I have a very big dataset in a gbd. I would like to export it to an excel file. I use the following code: startingP = r"C:\Directory\ArcGIS\By_Coding.gdb\MyInput" endingP = r"C:\Directory\ArcGIS\...
1
vote
1answer
19 views

Creating a sections polygon layer from tic points

I am working in Arcmap v10.3. I'm trying to create a "sections" (PLSS) layer from the section corners (tics). I know I could convert the points to X,Y coordinates and use the coordinates to create ...
0
votes
0answers
7 views

plotting a proportional sized snowfall fall pin ( also the numerical number) for 150 kal local ng positions on a us map

just starting to learn Grass. Need to learn how to have a usa outline map. (Is this spearfish?) On the map place pins ( for a given latitude and longitude) proportional in height for annual ...
1
vote
1answer
34 views

Exporting spatial population density data to Excel

I have spatial population density data that I would like to export to Excel (or similar) so that I can use it in analysis with another dataset. Specifically, I want the XY coordinates and the values ...
3
votes
0answers
57 views

Optimize CSV to QGIS workflow?

I am using statistical analysis software to pick out specific city lots within a database of around 500,000 lots. This is exploratory work and I'm mapping each test out in QGIS through an imported CSV ...
3
votes
3answers
73 views

Joining Excel File to ArcMap

I'm trying to join an excel file to ArcMap. The information in the excel file is clean and doesn't contain any characters that might hinder the joining process. However, when I join the file, all of ...
0
votes
2answers
32 views

CSV won't import correctly into Arcmap 10.3

I have a spread sheet with coordinates that once I bring in to Arcmap, the attributes disappear. The points are on the map, and when you Identify each point, the data shows up, but when the attribute ...
0
votes
0answers
32 views

How can I determine an appropriate query based on a join?

I am having trouble coming up with a query that will show the 12 states total population percentage in ArcMap 10.4. I created the spreadsheet below and I have already joined my excel to the states ...
1
vote
2answers
51 views

How can I display my Excel file in Arcmap 10.4?

I am currently working on a project. I have created an excel spreadsheet: So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
0
votes
1answer
38 views

ArcGIS: Add XY Data isn't plotting in the correct location.

I've done this correctly so many times, I don't understand what's wrong. The x and y columns I'm plotting are in decimal degrees. Latitude is X and Longitude is Y. I am plotting to Nad 1983 datum, ...
4
votes
0answers
52 views

Using one to many join to *.xlsx in ArcGIS Desktop?

I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file. The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the ...
1
vote
1answer
42 views

arcpy.TableToExcel_conversion works on layer but not if layer is variable

I'd like to loop through a bunch of mxds, on every layers, and from them I'm trying to export excel files. If I use a layer in arcpy.TableToExcel_conversion it works, but as I set a layer as a ...
1
vote
1answer
15 views

Does NetCDF4excel provide packed or unpacked values?

I'm using the NetCDF4excel tool to work on files from the ERA Interim database. I'm wondering whether I should adjust the values of the variables produced by the tool using each variable's "...
1
vote
1answer
114 views

Is *.xls MS Excel default format in ArcMap?

Is it always necessary that whenever we want to show our data kept in Excel spreadsheets in ArcMap, that it must be in .xls? Is .xls a default format for ArcMap?
2
votes
1answer
59 views

How to get gridded data in Excel into ArcGIS?

I am very new to using ArcGIS. Right now I have an Excel sheet with data in it where each cell represents a grid from a model output and contains a value (eg. amount of precipitation in that grid cell ...
2
votes
1answer
81 views

Importing XY coordinates to ArcMap?

I am very new to GIS. I have a dataset in Excel containing XY coordinates of points. These coordinates are said to be in WSG84, but have different decimal places lengths. Longest of them have 9 ...
1
vote
2answers
42 views

Geoserver - Layer creation via data import

We have about 400 sites (materialized by coordinates in the spreadsheet file to be imported) and several fields of information attached to these sites (coordinates, site ID, name, comments, category, ...
0
votes
0answers
6 views

Export excel with map embedded

In arcgis office you have a functionality to add a map to an excel. Now, i want to give an option to export an excel from my application(javascript, .net, or anything else) to allow the user to ...
2
votes
2answers
66 views

Output shapefile has no records after joining shapefile with table and exporting result?

I have successfully joined a .xls Excel spreadsheet to a shapefile. The join is successful (the number of remaining records seems accurate), although it takes a really long time (like 20 minutes). For ...
2
votes
2answers
82 views

ArcPy: Excel to Table Conversion and Join Management

I am trying to join an Excel table to a shapefile in ArcPy. My first step is to convert the Excel sheet to a table, but I am receiving an error: #Convert xlsx to table: import os import xlrd import ...
0
votes
0answers
39 views

Updating attribute table by CSV in ArcGIS for Desktop?

I have a File Geodatabase in ArcGis that contains shapefiles and tables. The tables must be updated using CSV or Excel files. The structure of the existing tables and the update csv will be exactly ...
2
votes
1answer
101 views

Creating shapefile from polygon points for CartoDB?

I have an Excel file that contains polygon coordinates for different areas. The spreadsheet has three columns: latitude, longitude and area name. Each coordinate makes of a part of the boundary of a ...
2
votes
1answer
56 views

QGIS Attribute update using excel

I am looking to update the Attribute table for a Layer in QGIS using a join. However I am not looking to ADD attributes to the table (thereby adding extra columns) rather I would like to "Update" ...
0
votes
0answers
25 views

What controls the insertion box for excel charts in ArcMap

I saw a related post here about inserting an excel chart to a layout in ArcMap and read the article. I still have a question about what controls the size of the insertion box in ArcMap. I'm trying to ...
2
votes
1answer
31 views

Turning simple Excel file into CartoDB map?

I have Field 6 in my Excel sheet as a column of Zip Codes. How do I get them to show up on the map using CartoDB? My map continues to be blank.
1
vote
1answer
72 views

Excel to Table Conversion Tool not working

When I input the table in the dialog box, I get this rather long error: ERROR updateParameters Execution Error: Runtime error Traceback (most recent call last): File "c:\program files (x86)\...
0
votes
1answer
23 views

How to remove XML tags within a field of attribute table?

I have this dataset I got it from Wikimapia ,containing bunch of fields . One of fields named "PopupInfo" contains xml tags : and looks like this when in editing mode : I want to remove these ...
3
votes
1answer
55 views

Generate new coordinates with distance + azimuth

I currently have the following Excel data for a list of animals: Lambert 93 coordinates of the observer Azimuth of the animal Distance between the observer and the animal I would like to get the ...
1
vote
0answers
31 views

Radiometric calibration NDVI values in Excel

I´m doing NDVI analysis, but i forgot to do Radiometric calibrations in QGIS. So the NDVI values in my excel table are in DNs. Can I do this calibration directly in excel?