16,012,843 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Amol Lendave (Top 12 by date)
Amol Lendave
16-Jul-15 3:44am
View
Thanks for quick response.
Can we do same using OpenOffice or any another option it should be open source.
Actually I'm not using MSOffice
Amol Lendave
18-May-15 6:52am
View
It me possible that column name is "A.B" at that time what i should do.
Columns are not fixed.
Amol Lendave
18-May-15 6:42am
View
Mean while i have created some changes that works me.
Added
Extended Properties=\"Excel 12.0;HDR=No;IMEX=1\"
into connection string.
"HDR=No and IMEX=1" will avoid conversion of First row to Columns.
After that i have converted first row to columns and 2nd to nth rows as table Rows.
This is not proper solution. but it works me fine.
Amol Lendave
18-May-15 6:00am
View
It's not feasible to replace # to ., if my column name is "C# .Net" it will convert into "C# #Net".
After # to . replacement "C. .Net" not acceptable any more.
Amol Lendave
18-May-15 5:52am
View
For .xls "Microsoft.Jet.OLEDB.4.0"
and for .xlsx "Microsoft.ACE.OLEDB.12.0"
for .xls = Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"
and for .xlsx = Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"
Amol Lendave
21-Aug-14 6:56am
View
Thank you so much..
It helps me
Amol Lendave
25-Jun-14 11:30am
View
: = will not matter.
Issue is i am having CSC with 4.somthing
By using that i am converting XXX.dll to strongly typed XXX.dll.
But it will get the newer version that is i am currently used. That i don't want
What i can do to get the older version CSC so i can convert it into 3.5 (I want V3.5).
Amol Lendave
25-Jun-14 7:55am
View
No by mistekan space was ther
ilasm SomeAssembly.il /dll /key=keyPair.snk
it is working but the version of the dll is get changed with Current CSC(C# Compiler) version
Amol Lendave
12-Mar-14 8:11am
View
How i can get class name of on which this attribute fire?
That's my question dear.
Amol Lendave
6-Dec-13 4:47am
View
Thank you for assist...
Amol Lendave
3-Dec-13 4:26am
View
Finally i got LoopBack ip i.e 127.0.0.1 .
Can i restrict to retrieving machines ip instead of loopback ip.
Amol Lendave
3-Dec-13 3:58am
View
Ya i have tried it gives me ip of proxy i don't want it, i just want ip of local machine.
I google it but still i didn't get propper solution.
Show More