Ask a Question

Saving XL file gives disc full error

NisHera
Valued Contributor

Saving XL file gives disc full error

Hi,

When I' saving excel file in script gives "disck full" error.

have around 45GB file is just 75KB.

 

following is code...

function WriteExcelSheet(){
var todayD, hireDate ;
  var xlRange,rowCount,adjtTotal;
  var app = Sys.OleObject("Excel.Application");
  var book = app.Workbooks.Open(dtaFile);
  var sheet = book.Sheets('mySheet');
  todayD = aqDateTime.Today();
  hireDate = aqDateTime.AddDays(todayD, -85);
  Log.Message(aqConvert.DateTimeToStr(myDate));
  app.DisplayAlerts = false;
  app.Visible = true;
  //xlRange = app.Range('A1').Activate(); 
  
  rowCount = sheet.UsedRange.Rows.Count+1
  Log.Message('Number of rows = '+rowCount);

  for(j=11;j<rowCount;j++){
      app.Cells(j,10) = hireDate;
       }
  book.Save();
  Delay(7000);
  app.Quit();
}

the error fire at  book.Save();

 

This dosn't happen ervery time but after running long time randomly

5 REPLIES 5
tristaanogre
Community Hero

Re: Saving XL file gives disc full error

I'm wondering if "Disc Full" is not exactly the correct erro, even if that's what's being returned.  I tcould be permissions or access on the folder in question.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
TanyaYatskovska
Community Manager

Re: Saving XL file gives disc full error

Hi @NisHera,

 

Was the cause of the problem related to permissions?

 

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


NisHera
Valued Contributor

Re: Saving XL file gives disc full error

not sure ..!

there are security changes being happeing ..so could be it.

TanyaYatskovska
Community Manager

Re: Saving XL file gives disc full error

Just to clarify - was the issue resolved?

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Laura974
New Member

Re: Saving XL file gives disc full error


@9apps download wrote:

Just to clarify - was the issue resolved?


Sorry but not familiar with the topic.

cancel
Showing results for 
Search instead for 
Did you mean: