• Export SQL Server to Microsoft Excel with column headers

    In SQL Server, I have a query that has roughly 20 columns and this needs to be exported to Microsoft Excel with the column headers. What's the process to do that? Thanks so much.

    ITKE434,585 pointsBadges:
  • Export data from Delphi to Microsoft Excel

    I'm looking to export my data to Microsoft Excel from Delphi but I'm not sure about the process. I tried CSV but that didn't work. What's the best way to do it?

    ITKE434,585 pointsBadges:
  • How to hyperlink Microsoft Excel 2010 text only

    Does anyone know of a way I could add a hyperlink to my text only and not my Microsoft Excel 2010 cell? I keep trying but it's affecting the entire cell. I also don't want to use Visual Basic too.

    ITKE434,585 pointsBadges:
  • How to convert HTML files to Microsoft Excel

    I have a bunch of HTML files that I need convert over to Microsoft Excel. Would I be able to change the content of the files to XLS / XLSX? Thanks!

    ITKE434,585 pointsBadges:
  • How to connect SQL Server to Microsoft Excel

    I'm looking to connect several reports from my SQL Server database so several end users can view them. Would I be able to connect SQL Server to Microsoft Excel? Thank you very much.

    ITKE434,585 pointsBadges:
  • Lock data in Microsoft Excel cell using VBA

    In Microsoft Excel, can I stop other users from editing the content in a certain cell using VBA? Basically - I need to lock the data.

    ITKE434,585 pointsBadges:
  • Formatting Microsoft Excel cells programmatically

    We currently have an ASP.NET C# program that's been reading from an Excel spreadsheet and it writes a brand new sheet. But here's our issue: That new sheet is not formatting the data correctly - it's adjusted to the right of the sheet. We need it on the left.

    ITKE434,585 pointsBadges:
  • Remove carriage returns in Microsoft Excel cell

    Hi all, Does anyone know how to remove all of the carriage returns in a Microsoft Excel cell? Appreciate the help.

    ITKE434,585 pointsBadges:
  • Find Microsoft Excel cell color

    I don't want to use any macros for this but how can I find out the color of a Microsoft Excel cell? Is there some formula I have to use? Thank you.

    ITKE434,585 pointsBadges:
  • Export Microsoft Excel data to SQLite database

    My Excel spreadsheet is full of data and I need to export it to a SQLite database. Right now - I'm just doing it manually. How can I export it automatically? Thank you very much.

    ITKE434,585 pointsBadges:
  • Show long Microsoft Excel numbers

    Our department has a C# program that actually makes CSV files and puts in very long numbers (as a string). But we notice that when we opened it in Microsoft Excel, it's adding a bunch of extra characters. Is there a way for us to keep the formatting of the long numbers? Appreciate the help.

    ITKE434,585 pointsBadges:
  • How do you convert Excel file to XML

    How do you convert an Excel file to a Macro File XML

    DavidWilliams695 pointsBadges:
  • Delete characters in Microsoft Excel cell

    Hi experts, Can anyone tell me how to delete certain / specific characters inside a Microsoft Excel cell? Basically - I have a name that's surrounded by brackets. I want to remove the brackets. How can I do that? Thanks!

    ITKE434,585 pointsBadges:
  • Rename Microsoft Excel worksheets using C#

    I recently created a Microsoft Excel workbook that has name sheets (like sheet1, sheet2, etc.). Would I be able to rename these sheets dynamically using C#? Thank you.

    ITKE434,585 pointsBadges:
  • VBA: Set bold on specific text in Microsoft Excel string

    In Microsoft Excel / VBA, can I bold specific text in my string that would go into my cell? What formula should I use?

    ITKE434,585 pointsBadges:
  • VBA: Call FM SAPWL_STATREC_READ_REMOTE failed

    Hi Experts, We monitor the response time of different SAP and Customer programs before and after any release change. We use the workload statistics in transaction STAD and export the data into Excel manually. We would to automate this process by using Excel VBA Script and download the workload...

    walidde20 pointsBadges:
  • How to best protect Microsoft Excel database

    I currently have a Microsoft Excel database that's been performing a few different macro functions and it needs to be sent out to various people. But I don't want them to see how the macro works. What would be the best way for me to protect that? Can I password protect it?

    ITKE434,585 pointsBadges:
  • Create Microsoft Excel document in ASP.NET

    Would I be able to create a Microsoft Excel document using ASP.NET? I have to send a customer constant documents through a browser using XML or LINQ. What's the best way here? Thank you.

    ITKE434,585 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE434,585 pointsBadges:
  • Activate Microsoft Excel worksheet

    For Microsoft Excel - I have to activate one specific worksheet. I already created a variable that will keep the name of my worksheet. How can I go about doing this? Thank you.

    ITKE434,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following