3,887 questions
Did you mean when you try to import Excel file to somewhere? Lose data? What kind of Excel file format did you use? If you're using .xlsx, please re-save it as .xls and check the result.
Weird Excel error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Fredrik M
246
Reputation points
Hi,
I have a package inporting rates from an excel doc and it has been running for years, monthly. Now they have automated the process in creating the doc in someway. When I look at the old excel document and the new autogenerated one, I see absolutely no difference. Everything is the same, column, formats, significant numbers etc.
The weird thing is that it read only half of the columns and then everything after that is set to null.
But if I open the excel and just save it, don't have to edit anything in the document, it works just fine, all the column is imported as they should. I have run out of ideas how to fix this. Anyone have a tip on what I can do ..?
Microsoft 365 and Office Excel For business Windows
{count} votes
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2020-08-28T09:30:49.423+00:00 I am just writing to see if you have obtained the opportunity to test the solution. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
2020-09-07T09:55:36.967+00:00 Hi @Fredrik M ,
Did this problem resolve now? If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sign in to comment
3 answers
Sort by: Most helpful
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
2020-08-19T08:20:31.217+00:00 -
MotoX80 36,291 Reputation points2020-08-19T10:30:31.493+00:00 The key sentence is "Now they have automated the process in creating the doc in someway.". You need to talk to whoever "they" is and ask about the "someway" process. Forum user have no way of knowing what you and your organization is doing.
If "they" are now using software like ExcelWriter, then I would suspect a bug in the process or in the software.
-
Fredrik M 246 Reputation points
2020-08-19T13:17:33.457+00:00 Yes, I have a meeting on Friday with the guys processing the file, where I get an opportunity to see what is going on.
I was just preparing if I could fix this in any way on my side. The only solution I came up with is a script task that opening the Excel, save it, and close it.
This code:
Dim appexcel As Object Dim Newbook As Object Dim Filename As String = Dts.Variables("Filename").Value.ToString() appexcel = CreateObject("Excel.Application") Newbook = appexcel.Workbooks.Open(Filename) Newbook.Save() Newbook.Close(True) appexcel.quit()...and it works! But only on my desktop of course, the server where the job is running, doesn't have Excel. And I guess I need a full installation for this?
-
MotoX80 36,291 Reputation points
2020-08-19T22:45:21.4+00:00 So it sounds like the .xls file is "close" but there is still some incompatibility. There is not a lot that we can do to help you until you figure out how the file is being created.
Sign in to comment -
-
Nobuko Ichimaru 316 Reputation points2020-10-10T11:00:39.957+00:00 Hi! @Fredrik M
It is suspected that it does not recognize the Excel column name.
For example
The column names in the previous file were read from the name list,
and entered the column name of the new file directly.
Are the settings and corrections made properly if when the name list is linked with INDIRECT?
I don't know until I actually look at the file,
Check for the existence of the previous Excel name list.
I hope it will be a hint