• Change Microsoft Excel font size using Python

    In Microsoft Excel - my content has to have Times New Roman font and the size has to be 18. Can I use a script in Python? Thank you!

    ITKE983,175 pointsBadges:
  • How to copy Microsoft Excel worksheet using Apache POI

    Would I be able to copy my entire Microsoft Excel sheet to another sheet (that's in the same workbook) using Apache POI? Can I clone the sheet? Appreciate the help.

    ITKE983,175 pointsBadges:
  • Convert Excel file to PDF using Java

    I currently have an Excel file that needs to be converted over to PDF. Is there a way to do this in Java? Thanks so much.

    ITKE983,175 pointsBadges:
  • How to find out which Microsoft Excel sheets have macros

    I have a Microsoft Excel workbook that has several sheets. These sheets have many macros inside of them too. But I can't figure out which sheets have them. The only way I found is to click on each of them using Project Explorer / VBA. Is there a better way to do this? Thank you.

    ITKE983,175 pointsBadges:
  • Convert HTML report to Microsoft Excel

    I'm creating a specific report in a HTML table format. I currently have this report on my browser but I need to download this report in Microsoft Excel. How can I do that?

    ITKE983,175 pointsBadges:
  • 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.

    ITKE983,175 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.

    ITKE983,175 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!

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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.

    ITKE983,175 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!

    ITKE983,175 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.

    ITKE983,175 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?

    ITKE983,175 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:

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