473,503 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Delete entire Empty or blank columns in Excel

1 New Member
I am drawing an rdlc report which I am saving to Local folder though my code as Excel file. Now I want to convert this file into CSV. But as my columns are dynamic in rdlc there gets inserted some blank or empty columns i.e zero width column. As a result after converting the Excel to CSV there also gets inserted a blank or empty column. In the CSV it inserts a comma for a blank. So any way how to delete empty column with no header or blank column so that my CSV file doesnt get inserted with blank columns. I am using Microsoft.Office.Interop.Excel for the above operation. Please refere the attachment for you reference. In the attachment there is one column that is blank likewise there are many.
Thanks in advance
Attached Images
File Type: jpg 11-11-2016 12-50-33.jpg (44.7 KB, 505 views)
Nov 11 '16 #1
1 4017
Luuk
1,047 Recognized Expert Top Contributor
Seeinng that you did not receive respone, I Googled for:
"Microsoft.Office.Interop.Excel empty column"

The first link (to statoverflow) was revealing code that showed how to remove empty columns in Excel using Microsoft.Office.Interop.Excel
Nov 26 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1724
by: Mahesh Kumar | last post by:
hi, I have two excel files(a1.xls and b.xls) each having 4 sheets. I want to read datas of 4 sheets from b1.xls and it has to be inserted in a1.xls as 4 sheets. First it has to delete all datas...
4
30120
by: B.N.Prabhu | last post by:
How to delete first row from an Excel Sheet using C#.Net. Please Help. Its very urgent.
5
6274
by: ajay m | last post by:
hi, i am new to perl I am looking for a simple script to delete non empty folder. Remove Directory and File(s) plz help me...
0
2612
by: Pasquale | last post by:
I have a form with 8 fields, 4 of which are required and 4 are not. Usually if a field isn't required I would create a separate table for it rather than having a blank value in the table where...
2
4412
by: Banditzika | last post by:
Hello everybody, I have questions relating xls-files. I have to write a script in perl in which I parse an excel file. My problem now is that I must delete some rows from the xls-file and I...
2
4809
by: omar999 | last post by:
hi guys I hope the thread title is self explanatory but im basically I've got a rather large ms sql table which is populated with data taken from an excel spreadsheet. Problem is that there are...
5
2822
by: ncsthbell | last post by:
I am using a query to select my columns from a table and then I am using the export function to export the results to an excel spreadsheet. I need to add to blank columns to the end, "Verified Year"...
43
15864
by: Ehsan arman | last post by:
Hi guys, I have a bunch of excel files stored in a folder and have a code to choose the appropriate excel sheet by opening up a dialog box. However, each excel sheet has a row which include the...
1
1420
by: bpremlatha | last post by:
I'm very new in using VBA. The excel table has more than 500 rows. I would like to run vba code to remove row where column A is empty. I tried run this code. Sub DeleteAlternateRow() Dim i...
6
1456
by: jdusn1978 | last post by:
Memos Query - sort of looks like: Expr1: MainTable.ID (the link between tables) Expr2: Table2.Memo Expr3: Table3.Memo Expr4: Table4.Memo Expr5. + + I've tried writing Expr5 as IIf, Is...
0
7202
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
6991
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7462
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5014
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4673
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3167
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
382
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.