topic Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing in Geoprocessing Questions

Importing an excel Spreadsheet as Object - Whole Column is disappearing

TanyaMcintyre — Thu, 25 Sep 2014 21:34:26 GMT

I've imported 5 different spreadsheets, and on 2 of them the last column has disappeared.

I tried changing the size of the font didn't help. I tried setting a print area.

Please someone help me with this frustrating issue.

Thanks!

Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing

JessiecarEsguerra — Thu, 25 Sep 2014 21:37:30 GMT

What is the exact header name on your spreadsheet that is missing? Is there an special character on it?

Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing

TanyaMcintyre — Thu, 25 Sep 2014 21:41:47 GMT

The Header name is AREA. Its a list with a bunch of columns and it has Job Title, Name, Area as the headers.

as i menioned 5 spreadsheets all the same, but 2 show up with the last column missing.

Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing

JessiecarEsguerra — Thu, 25 Sep 2014 21:48:47 GMT

One of the cause of the missing header that I experienced was that the header name has space/s and I just added underscore on it and it work. Have you set the target correctly during loading of schema?

Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing

TanyaMcintyre — Thu, 25 Sep 2014 22:03:01 GMT

Well, I'm not sure what the problem is/was, but after carefully adjusting the columns to not have any extra space and even adjusted some font size and it fit. BUt if i move it even a millimeter, the column disappears!
It is still frustrating however, becuase now some words in some of the columns are slightly smaller. I'm just glad the column re-appeared!

Thanks for responding.

Re: Importing an excel Spreadsheet as Object - Whole Column is disappearing

JessiecarEsguerra — Thu, 25 Sep 2014 22:06:53 GMT

Glad to help.