Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Go Back  Xtreme Visual Basic Talk > > > Guidance on how to handle large data in excel using vb.net


Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2014, 04:18 AM
bellaelysium bellaelysium is offline
Regular
 
Join Date: Jun 2008
Posts: 91
Question Guidance on how to handle large data in excel using vb.net


Hi,

I have a question regarding manipulating data in Excel using vb.net.

I actually have massive of data in a workbook...so here's the workflow of what I am going to do.

I want to do many possible divisions of the cells in that column. So as shown in the picture, the light blue means [All cell]/[first cell], and dark blue means [all cells]/[second cell] and continue on until the last cell in column E. Then from there, it will be inverse division e.g.[first cell]/[all cells], [second cell]/[all cells] and so on. So it is like doing all possible combination of division.

So next column will be the same as the previous column, where you do all possible division in Column F.


So once that is done, I want to do some filtering to filter most data based on certain conditions so that I will end up with only a very small bunch of data.

However, the problem here is that since my data is huge, it will cause excel to slow down and I am not sure if it will hit the limit of its no. of rows and columns. So is it possible to actually do the calculations and filtering "behind the scene" before displaying it in Excel as final outcomes?


Pls give me some guidance on how to start on it. So far, I have manage to open excel file using openfiledialog but is unsure of how to proceed on.


PS: I have done manually (tedious!) and it cause Excel to lag or even hang before I am halfway through the data. Hence, I wanted to do it in automated way.
Attached Images
File Type: jpg Division combination.jpg (97.8 KB, 7 views)
Reply With Quote
  #2  
Old 03-10-2014, 08:54 AM
VBobCat's Avatar
VBobCat VBobCat is offline
Freshman
 
Join Date: Aug 2009
Location: São Paulo, Brazil
Posts: 38
Default

There are many ways you could do this, but the choice depends on how experienced you are in VBA.
Regardless of that, you can considerably reduce lag and crashing in excel by disabling automatic recalculation. Have you already tried that?
Reply With Quote
  #3  
Old 03-10-2014, 07:34 PM
bellaelysium bellaelysium is offline
Regular
 
Join Date: Jun 2008
Posts: 91
Default

I have switch to using PERL instead and so far so good. Thanks by the way
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
 
Guidance on how to handle large data in excel using vb.net
Guidance on how to handle large data in excel using vb.net
 
-->