Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VB.NET and Excel: Determine Cell Descriptor from Array Upper Bound

Posted on 2013-01-04
5
Medium Priority
?
379 Views
Last Modified: 2013-01-11
When you have a large array, how can you  quickly dump it to an Excel range?   Thus far, I am using something like:

Sheet.Range("A1", "BC2000").Value = xmatrix

Open in new window


But I need to dynamically determine the "BC2000" based on the upper bounds of the array.  How can this be done?
0
Comment
Question by:lep1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 35

Expert Comment

by:Norie
ID: 38747028
Use Resize with the dimensions of the array to get a range that matches the size of the array.
0
 

Assisted Solution

by:lep1
lep1 earned 0 total points
ID: 38748734
My array is xarray(,) and the following was required in order to successfully fill the range using autosizing.   Thus, resize was not enough:

            Dim oXL As Excel.Application
            oXL = CreateObject("Excel.Application")
            oXL.Visible = True
            Dim oWB As Excel.Workbook
            Dim oSheet As Excel.Worksheet

            ' Get a new workbook.
            oWB = oXL.Workbooks.Add
            oSheet = oWB.ActiveSheet
            oSheet.Name = "mytest"

            Dim Rng As Excel.Range
            Rng = oSheet.Range("A1", Reflection.Missing.Value)
            Rng = Rng.Resize(xarray.GetLength(0), xarray.GetLength(1))
            Rng.Value = xarray

Open in new window

0
 
LVL 35

Accepted Solution

by:
Norie earned 80 total points
ID: 38748833
I don't quite see why Resize wasn't enough.

You've used it with the dimensions of the array to get the correct range.
0
 
LVL 35

Expert Comment

by:Norie
ID: 38749439
Apologies, I assumed that you just needed a pointer because you only posted one line of code which I assumed was part of a larger block of code.
0
 

Author Closing Comment

by:lep1
ID: 38766423
It would be more helpful for expert to provide all code necessary for solving an issue, and not to give pointers that cause users to continue to look for solutions.  I think users are not seeking coaching, rather explicit detailed solutions.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question