Assign Excel Range to a Javascript Array

Question

I'm working on some code to export a DataTable to Excel, and I'm trying to make it as fast as possible. Right now, I'm looping through each row and each column for each row (nested for loops). When I've got a large DataTable, this process can take some time. Can I assign a range of cells to an array in Javascript instead of looping through the columns?

Here's a sample of what I'm doing.

for (var rowIndex = 0; rowIndex < json.worksheets.raw.rows.count; rowIndex++) {
    row = rowIndex + 2;
    for (var columnIndex = 0; columnIndex < json.worksheets.raw.rows.values[rowIndex].length; columnIndex++) {
        column = columnIndex + 1
        XLWorksheet.Cells(row, column) = json.worksheets.raw.rows.values[rowIndex][columnIndex];
    }
}

I get the JSON data using an AJAX call to a web service in my ASP.NET project.

Could you add tags for people to understand, where json.worksheets come from? — shahkalpesh
– shahkalpesh, Commented Jun 25, 2009 at 17:55
is there a framework that has the object model with json.worksheets object? — shahkalpesh
– shahkalpesh, Commented Jun 25, 2009 at 17:56
json.worksheets is a property of my json data after doing the eval() call. No framework. — Tim Scarborough
– Tim Scarborough, Commented Jun 25, 2009 at 19:26

GSerg · Accepted Answer · 2009-06-25 17:24:58Z

1

You can do XLWorksheet.Range("A1:C100").value = arr, if arr is an array of VARIANT.

answered Jun 25, 2009 at 17:24

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Tim Scarborough Over a year ago

I tried setting the value to an array, but Excel put a comma separated list of the values into each cell. Is there a VARIANT array in Javascript?

Tim Scarborough Over a year ago

Created a dictionary and passed that in as the value. Works! Thanks!

Wolfgang Kuehn Over a year ago

And exactly what did you do? Assigning a JavaScript Object does not work, nor does a new ActiveXObject("Scripting.Dictionary"). So what's this dictionary of yours?

manuell Over a year ago

Please, @TimScarborough How did you do that? (Created a dictionary and passed that in as the value)

Tim Scarborough Over a year ago

@manuell sorry, but I asked this question a decade ago. I don't even remember what project this was on.

Collectives™ on Stack Overflow

Assign Excel Range to a Javascript Array

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related