• How to delete duplicate Microsoft Excel items

    In my Microsoft Excel sheet, I have several columns, with data, that has cells with duplicate content. Basically - the items occurs more than once. How can I delete these duplicates? Thanks so much.

    ITKE827,975 pointsBadges:
  • Java program that reads / writes Microsoft Excel files

    I've been trying to write a Java program that would have to write / read from different Microsoft Excel files (doesn't matter about the format either). Can I do that? I looked at Apache POI but that didn't work.

    ITKE827,975 pointsBadges:
  • How to delete empty Microsoft Excel rows using VBA

    What's the best way to delete empty rows in Microsoft Excel using VBA? I tried several times but I keep getting this error message: Run time error '1004': No cells were found. Thanks!

    ITKE827,975 pointsBadges:
  • How to save Microsoft Excel worksheets as CSV files

    I have to analyze several Excel worksheets. Afterwards, I have to save them as .CSV files and I'm not sure how to do that. What's the best way to do it? Should I use a macro?

    ITKE827,975 pointsBadges:
  • 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!

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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?

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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!

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 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.

    ITKE827,975 pointsBadges:
  • How do you convert Excel file to XML

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

    DavidWilliams695 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