|
by: RR |
last post by:
Normally when I run a query, each record is displayed in a row, and the
colums contain the field titles.
Is there a way to switch this and have each record in a column, and the
names of the fields would be the rows?
This will need to be exported to excel. That part I understand, just not
changing the rows and columns around.
|
by: Weyhooi |
last post by:
Help ! please help! i can't find the way to insert a new
blank row into excel worksheet using C#. Example macro in
vb6 as below :
Rows("15:15").Select
Selection.Insert Shift:=xlDown
i have searched through the net but still can't find the
solution.
|
by: javzxp |
last post by:
Hi
I'd like to use C# to open an existing Excel workbook and save each
worksheet it contains into a new Excel file. The name of each new
Excel file should be the name of the worksheet copied from the existing
file.
So, as an example:
|
by: sunilkumar Reddy via DotNetMonster.com |
last post by:
hai all
first we have taken binded grid
Export to excel data from ultrawebgrid (or) datagrid rows,
Each row data Expoting to one worksheet in excel workbook,
like as
grid row1 data contain sheet1
grid row2 data contain sheet2
grid row3 data contain sheet3
we have pressing one button ultrawebgrid (or) datagrid rows data to export
|
by: Anand |
last post by:
Greetings,
How can I find the number of active columns and rows used in an excel work
sheet?
What I mean is how can i find the last column and row or cell position,
where the data is stored in an excel sheet?
A code snippet would be of great help.
Thanks for your cooperation and help.
|
|
by: Gary |
last post by:
Hi, there,
I have an xls file, and need to get the number of nonempty rows from one
worksheet. How to know what is the last line of this worksheet?
I am using Microsoft Excel 9.0 library, Excel 2000, and C#.
Thanks,
Gary
|
by: Shelley |
last post by:
Compare Current Year Worksheet with Previous Year Worksheet and if SSN exists in Current Year Worksheet & Not in Previous Year - Copy this Row from Current Year Worksheet & Paste into Previous Year Worksheet
Compare Previous Year Worksheet with Current Year Worksheet and if SSN exists in Previous Year Worksheet & Not in Current Year Worksheet - Delete this Row out of Previous Year Worksheet - THIS IS WHERE I'M HAVING TROUBLE.
This is the...
|
by: WWUser |
last post by:
I have an Excel workbook where data of a particular type is separated by "header" rows using colons to specify the data type:
:DataType1
FirstDataPoint
SecondDataPoint
ThirdDataPoint
:DataType2
FirstDataPoint
SecondDataPoint
ThirdDataPoint
|
by: haroldburgess |
last post by:
I'm using the Jet provider to connect to an excel spreadsheet to load into a dataset. the problem is when i use the hdr=no extended property, the provider auto adds f1, f2, f3... as new first row. you can't even delete the row from the dataset, which shows row 0 as first populated row from excel results.
if i say hdr = yes, and the worksheet has blank values in first row of cells, i get the f (n) in that column. so if column 1 was blank...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|