Import raster into ArcGIS

Question

I received raster data from a grid of 1100 by 1000 meters with a resolution of 1 meter. It is the output of EFC-400 software showing the field strength around power lines. The data is currently in Excel format and I want to use the raster in ArcGIS 10.2. In Excel the raster looks as follows:

x\y[m]                          
B[uT]   0   1   2   3   4   5   6  
0   0.01    0.01    0.01    0.01    0.01    0.01    0.01  
1   0.01    0.01    0.01    0.01    0.01    0.01    0.01  
2   0.01    0.01    0.01    0.01    0.01    0.01    0.01  

etc...

The second row indicates the y-direction (0-1000 meters) and the first column indicates the x-direction (0-1100 meters). I assumed that removing the first 2 rows and the first column and subsequently adding the header that ArcGIS expects would make the import in ArcGIS possible. I added the following header to the Excel sheet:

ncols 1001
nrows 1101
xllcorner 0
yllcorner 0
cellsize 1
nodata -9999

and saved the data in .txt format. In Notepad I made sure that all datavalues were separated by a space. In ArcGIS I used 'ASCII to raster'. This gave no error message, but the shape of the resulting raster does not resemble the original raster:

The raster should show two powerlines approaching each other. Anyone any suggestions?

Answer 1

From Esri grid - Wikipedia:

So your example should be converted like this:

NCOLS 7
NROWS 3
XLLCORNER xxxxxxx
YLLCORNER yyyyyyy
CELLSIZE 1
NODATA_VALUE -9999
0.01 0.01 0.01 0.01 0.01 0.01 0.01
0.01 0.01 0.01 0.01 0.01 0.01 0.01
0.01 0.01 0.01 0.01 0.01 0.01 0.01

where xxxxxxx and yyyyyyy are the coordinates of the lower left corner of your raster. Change the other values accordingly. Hope this helps.