Vb.NET SaveAs not saving all Excel data

Posted Jan 01, 1970 12:00 AM

I have a very strange issue that I cannot seem to find an answer to online.

I have a VB.NET application that creates an Excel of data (roughly 42,542 rows in total) and the saves the file to a folder location & opens it on screen for the user.

The onscreen version & folder version is only showing 16,372 rows of data like it is being cut off.

When I go through debug I can see all the rows are being added & if I save manually in debug all the rows save. Some data seems to get lost on the system save.

I am taking data from 4 record sets & writing each set one after the other with specific headers for each block on the Excel sheet.

My save line is:

xlWBook.SaveAs(Filename:=sFileName, FileFormat:=Excel.XlFileFormat.xlExcel7)

Would anyone please have any ideas as to what this might be?

Many Thanks.

Tagged vb.net excel

Similar Topic Questions

Error importing and exporting excel data to vb.net, "Microsoft.Office.Interop.Excel.Application is not defined"

I am trying to run a file I downloaded to import and export data from excel. I downloaded from from the following site: http://www.sattsoft.com/sourcecodes/details/1/9/import-export-data-to-excel-using-vb-net.html When I run the file the error comes on the following lines Dim xlApp As...

Posted Jan 07, 2014 7:47 AM

Vb.net create project to check excel column data in sql and update in excel as exist or not exist

I am New in coding so please help to find out the way to make vb.net project to create vb.net project to check excel column data in SQL Server and update in excel as exist or not exist. I want to...

Posted Jan 14, 2014 11:45 AM

Exporting data to MS EXCEL in vb.net appication not working for win xp

I am using Imports Excel = Microsoft.Office.Interop.Excel for exporting datagridview data to MS Excel. It is working fine in windows 7 when we install the microsoft office package. But it is not working in window xp even i install...

Posted Feb 18, 2014 12:50 PM

Need help with error saving using Excel data in VB

I am trying to make a form in VB that provides access and allows end users to edit data in an Excel database. I have tried running it in XP and Windows 7 and get the same error. It runs...

Posted Jan 27, 2014 4:22 AM

Inserting Data in sql database vb.net is not getting stored

I have a weird problem: I'm trying to do some basic procedure to insert data in a database and I don't know what it's happening, but it does not work. The thing is that I have a database called prova3 that...

Posted Mar 26, 2014 2:13 AM

VB.net width/height of all screens

I'm trying to capture any and all screens on a computer, I tried to fiddle with Screen.AllScreens and also something with VirtualScreens that I can't remember, so I moved to PrimaryScreen to make sure everything else worked properly. Here is my...

Posted Dec 10, 2013 2:22 AM

Vb.net Form not enabled after calling function from another

Hey all i am not sure whats going on with my form but when i click on a link on (lets called it Form1) using this code: Me.TopMost = False Me.Enabled = False reply.theID = "stuff" reply.Show() This works as it should (disables the form1...

Posted Dec 13, 2013 1:03 AM

VS 2010 Is it possible to extract a range of video using vb.net and not just a single frame??

I'm looking to write a program to make it easier to a create highlight video at season's end. During the season, as the games are initially viewed, a spreadsheet is kept that tracks an individual, video filename, as well...

Posted Dec 23, 2013 9:48 AM

Vb.net timer not working like I want

I have a timer in my program, the timer triggers a progress bar and when the progress bar is done it makes a label visible. The problem is that the label becomes visible before the progress bar finishes. here is...

Posted Dec 23, 2013 6:33 AM

VB.NET: The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception

I don't know what may be wrong but that's what I get when I try to start the program: The type initializer for MySql.Data.MySqlClient.Replication.ReplicationManager threw an exception. The problem appears to come from conn.Open() This is part of my code: Imports MySql.Data.MySqlClient Public Class Main Dim...

Posted Dec 25, 2013 7:09 AM

Php/rpc will not connect. all configuration data is set correctly, no firewall

Having a huge issue connecting to bitcoin. This is the error: 'Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to http://xxxxxxxxxx:xxxxxxxx@home.IP.here:41337/' in /home/content/61/11420661/html/massivetest/jsonRPCClient.php:140' See: http://nobanchan.com/massivetest/index.php (source of the error) <?php require_once 'jsonRPCClient.php'; $coinye = new jsonRPCClient('http://SOMEUSERNAME:SOMEPASSWORD@IP.I.need:41337/'); echo "<pre>\n"; print_r($coinye->getinfo()); //print_r($btc->getinfo()); echo "</pre>"; ?> this is the...

Posted Jan 08, 2014 5:27 AM

Vb.net - Items not deleting from LIST

I have a list that I am using to hold a queue of commands. I need to loop though each item of the queue, executing the commands, deleting them as it goes along. The items weren't being deleted from the...

Posted Jan 13, 2014 11:10 AM

VB.NET Code not executing the way it should under Visual Studio

Hi I would like to ask a question guys I am doing an application in vb.net and my if else is acting weird instead of stating the correct caption in the label it shows the else statement instead which is...

Posted Jan 30, 2014 6:17 AM

Vb.net connection timeout while generating excel report

I am trying to generate an excel report using the data from MSSQL. It is perfectly working on my pc(server) and all clients except those PC that has windows 8 installed(MS Office 2010 installed). I tested the program in WinxP/win7...

Posted Feb 02, 2014 11:31 AM

Vb.net program not running on mac with windows vmware fusion? CLR20r3

Hi I've written a program for my dads company in vb.net and the release version runs fine on my desktop and other laptops we have but it wont run on my dads mac with a windows 8 VM installed. Below...

Posted Feb 18, 2014 2:37 AM

Wamp Server not getting all post data

I created a large form where user can set permission for different user group for role based system. it list all the modules available in system in one column next 6 columns show different checkbox for permissions ('View','ADD','EDIT','Retore'...) so it become a...

Posted Feb 21, 2014 12:32 PM

Not getting all of data from Json object into database through PHP

I am trying to get all the Json data into my Mysql database through php, I have all my phone contacts details in this json object, But It only insert just one last phone contact detail to my database, please...

Posted Feb 23, 2014 5:35 AM

ASP.net is not passing all my parameters to SSRS....Need Help!

I am using an ASP.net 4.5.50938 front end to allow me to display and pass multiple parameters to SSRS. The problem is the below code is only passing 1 parameter but I have 8 parameters to pass based on...

Posted Feb 26, 2014 9:49 AM

Is it possible to have a radio button 'checked' by default in VB.NET but not have the app call it's clicked() event upon start?

I have a VB.NET application with a radio button that I want to be checked by default. But this is causing issues because on the radio button's clicked event there is a method call that is causing an error when...

Posted Feb 27, 2014 1:17 AM








Forgot Password
Reset my password!