• Query from Oracle forms to Excel sheet

    I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report builder. I am unable...

    Sarah1234520 pointsBadges:
  • Adding an editable Excel spreadsheet to a Lotus Notes form

    Hi, I'm totally new to Lotus Domino designer so please forgive me if this is an incredibly stupid question. I'm trying to add an editable spreadsheet to a form. It seems simple enough to add a spreadsheet attachment, however the attachment is not editable as the edit button is greyed out. I need to...

    TheBinman10 pointsBadges:
  • R6V1 iseries Excel Addin to download data from AS400

    On V6R1, how do I install the Excel Addin? The file that is in the shared folder for IBM does not have the cwbtfxla.xll like it did in R5.4

    Lorettarepman10 pointsBadges:
  • error in grid xml: each dimension must be used once and only once

    Hello, I've got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can't get data. It shows #NAZEV? instead numbers and popups Error window 'Hyperion Smartview for Office' with message "Error in grid...

    KAZAN5 pointsBadges:
  • Mail Merge

    I have an excel document from my accounting software that lists donors by each donation they have given. When I mail merge them I want to print one document for each name- putting more than one donation on each page. Meaning, I need to get more than one row on each page when the name is the same....

    Malachinetwork5 pointsBadges:
  • Data transfer from excel to PF

    How to transfer data from excel to PF if PF file has more the 300 Fields

    97834441841,400 pointsBadges:
  • How to Update Manager Field in Person Document

    HI,   It will be great, if anyone answer my query. I am searching for agent/script which can be used to update/modify Manager Field in Person document using Excel sheet.

    DominoDirectory5 pointsBadges:
  • Programming quiz – Excel, VB etc.

    Recently heard an interesting quiz and thought it will be fun to see the solution done programmatically. The quiz is as follows: A person bought an old car with over 170,000 miles on it. The odometer is a digital device with 6 digits. The odometer shows only full digits – no decimals. One day as...

    SbElectric2,540 pointsBadges:
  • Detecting MS excel is open in Citrix via Lotus Script

    I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel...

    WeDontByte30 pointsBadges:
  • Excel File from PL/SQL Procedure

    Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather

    HeatherM5 pointsBadges:
  • Append extra zero on the numeric field using Data Transfer Excel Add-in

    My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data...

    Mingwong30 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • extract data from as400 to excel

    I have CL and DB files and i need to extract the data from the files to excel sheet by writing an program.How can i do that?

    Copinky45 pointsBadges:
  • Save an Excel Add-in to a network drive

    I have a MSExcel 2010 workbook which uses a User Defined Function via an Add-in (.xlam file). Although the add-in is saved on a network drive, when I try to load it into my add-in list using the browse in the Add-in Manager, it prompts to copy the add-in to the default path on my harddrive:...

    CBURS5 pointsBadges:
  • Upload data from excel to lotus notes in web

    How to incorporate the facility to upload data from excel sheet to lotus notes web?

    shivasanjay2,660 pointsBadges:
  • find and replace in excel

    I want to use the find and replace feature under Edit. i want to find a word and replace that word in a difference format. For example, replace charcoal with [strong]charcoal [/strong](in red, bold format), but instead it replaces [strong]ALL the contents in the cell[/strong] with 'red, bold'. I am...

    Lrhehn5 pointsBadges:
  • how to export to excel in web with heading row frozen

    I want to export to excel report in lotus notes web, when report is available it should be showing Ist column as frozen, , ie. 1st row should not move when scroll bar moved to up and down.

    shivasanjay2,660 pointsBadges:
  • Can you show lotus notes table rows as rows in a view?

    I have a table with 5 columns. Each row as 5 fields. first row, Field A, Field B, Field C, etc second row, Field X, Field Y, Field Z, etc I need to be able to show the table rows as as rows in a view to export to excel. I have tried using a lot of formula language in column formulas and it is not...

    Penguins10 pointsBadges:
  • Data and Variables in SPSS from Excel spreadsheet

    have an Excel spreadsheet with responses to questions from a 49 question survey. At the top of the spreadsheet I listed each variable that the questions address. When I transfer this to the data page in SPSS, it lists the variables on the variable page with sequential letters after each variable -...

    Terrymb310 pointsBadges:
  • extenda x550 series

    I am using Extenda X550 (1+5) and having a typical problem while working in excel like - some area gets selected automatically - copy paste does not work - cursor starts moving weirdly

    Jaideep Khanduja9,470 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following