Skip to main content
Solved

Reupload standard Excel functionality fails

  • February 3, 2025
  • 3 replies
  • 54 views
D
AIMMS Partner
Forum|alt.badge.img+3

Hi community

We use standard Excel functionality to download a file of the following format:


Then we try to reupload this file after having made the following adjustment (we manually adjusted the columns A and B and copied the values in A2 and B2 from other Excel):

 


However, this reupload resuts in 0 changes being made to the table in the WebUI. What could be the reason the reupload fails to read in the 1000?

Best answer by MarcelRoelofs

​@danileidelmeijer 

My guess is because of the empty lines, which still hold styling information, but no data any longer. 

3 replies

gabiservidone
Administrator
Forum|alt.badge.img+6
  • gabiservidone
  • AIMMSian
  • 256 replies
  • February 10, 2025

Hello ​@danileidelmeijer, so you removed all the lines keeping only line 2? 

Can you test by only editing the blue column? 

Gabriela Servidone - AIMMS and Optimization Solutions Consultant
D
AIMMS Partner
Forum|alt.badge.img+3
  • danileidelmeijer
  • Author
  • AIMMS Partner
  • 7 replies
  • February 11, 2025

Hi ​@gabiservidone, what I did was removing all lines, then pasting line 2 from another Excel to this Excel and reuploading. Indeed, if I edit only the blue column then things do go well. But why does the upload fail if I manually type (or paste) the values 20001 and 10007 in A and B?

MarcelRoelofs
AIMMSian
Forum|alt.badge.img+5
  • MarcelRoelofs
  • AIMMSian
  • 107 replies
  • Answer
  • February 11, 2025

​@danileidelmeijer 

My guess is because of the empty lines, which still hold styling information, but no data any longer. 

Marcel Roelofs - AIMMS Product Portfolio Architect


Terms & ConditionsAccessibility statement

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator